Dynamic X axis on charts – Power BI

Posted by on Sep 18, 2017 in Power BI | One Comment

A recent post to the Power BI community desktop forums asked if it might be possible to allow a user to make a slicer selection that dynamically updates the x-axis.  The idea would be to present the end user with a slicer on the report page with options of Year, Quarter, Month and Day and when ...

Read More

Power BI Drill Through

Posted by on Sep 3, 2017 in Power BI | 7 Comments

An exciting new feature appeared in the Power BI web service yesterday.  This is the ability to define a report page as a drill through page.  So far I haven’t seen the September release of Power BI Desktop but I’d be very surprised if this wasn’t included in desktop.  But for the next few days ...

Read More

Taking a byte out of U-SQL

Posted by on Aug 31, 2017 in Azure Data Lake | No Comments

I recently had a requirement to combine a set of approx. 100 CSV files into a single file and encountered an interesting problem along the way. The files all had the same simple structure which was 2 columns.  I thought this would make a pretty straight forward exercise – until I started processing the files. I ...

Read More

Power BI – What If parameters

Posted by on Aug 11, 2017 in DAX, Power BI | 3 Comments

The latest release of Power BI Desktop (August 2017) contains a pretty cool feature that was teased back in the keynote of the Microsoft Data Insights Summit which is the ability to add What If parameters to your data model. To add a What If parameter, just click New Parameter on the the Modeling tab which ...

Read More

Measure table madness

Posted by on Jul 27, 2017 in Power BI | 2 Comments

Measure tables in Power BI models are a fantastic way to group your calculated measures together in one place and make for a tidy model. Unlike calculated columns, a calculated measure can be placed on any table so long as the best practice of using the table name for every column reference. Power BI desktop ...

Read More

2017 Data Insights Summit – Key Note (Live)

Posted by on Jun 13, 2017 in Uncategorized | No Comments

Not just one but TWO live blogs from Radacad running so you won’t miss anything! Reza is also blogging here http://radacad.com/microsoft-data-insight-summit-2017-keynote-live-blog 5 mins to go. Sitting between Chris and Alberto. We are delayed due to the massive influx of attendees queuing to get in. James Phillips speaking now Summit sold out 5 weeks early 2500 ...

Read More