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

Power BI – What If parameters

Posted by on Aug 11, 2017 in DAX, Power BI | 4 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

Dynamic distances in Power BI

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

I recently encountered a question posed to the Power BI community forum I found interesting enough to kick-start my blogging on Power BI. The essence of the question was asking how to dynamically determine distances between two geographic points from user based selections.  So I thought I would cover how this can be done in Power BI to ...

Read More