Data modelling and DAX
A question I come across in Power BI from time to time is how to configure a report to show an end-user a list of options, and then have visuals in the report use the selected item on the axis. There are a few ways this can get solved, such as using bookmarks. For this … Continue reading Power BI – Dynamic Axis
A question I’ve received a couple of times recently is how to override slicer selections in Power BI visuals. Or more specifically, if the user selects a specific item in a slicer (or filter), how can I show data for other items a visual that may be related by my selection. An example of this … Continue reading Overriding slicers
I came across an interesting request last week from someone who wanted to dynamically control columns shown in a Power BI table visual – based on the values within each table. There are lots of blogs showing different techniques on dynamic columns, but the requirement here was to base the decision on whether to show … Continue reading Dynamic Columns based on values
My last article described the Shadow Model data modelling technique and how you can use it to help resolve a specific performance challenge caused by tables forced to direct query mode in particular scenarios. The approach detailed in that article used the GROUP BY method of mapping “alternate of” columns which can result in unwanted … Continue reading Mixed Grain aggregations
