Power BI – Banding and stripes in charts

Posted by on Jan 11, 2018 in DAX, Power BI | One Comment

This blog will show a technique that can be applied to certain charts allow banding or stripes to help highlight data. This could be horizontal bands to help show data above or below a certain threshold, or this could be vertical bands to help highlight ranges of data by time.  In both cases, using What-If ...

Read More

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