Add pre-set filter buttons to a Power BI dashboard - a DAX approach

This video shows how to use DAX tables and measures and a slicer to create useful "pre-set" buttons so that users can easily apply a favourite set of filters. This technique has widespread application - each button can apply any filter conditions. It is an alternative option to the usual approach of using bookmarks - and one I prefer because it is elegant, flexible and versatile.

If you would like to download the Power BI file that was built in the video, here is the link. https://github.com/MarkWilcock/lbag-o...

The previous two videos in this playlist build the Power BI report that is the starting point of this example.

Timestamps
00:00 Introduction
01:00 The four steps: build a preset table, add a slicer, write a measure and add it to a filter card
01:28 Build the Preset table to contain the button labels
02:05 Add a slicer based on this Preset table and configure to look like preset radio buttons
02:37 Build the skeleton of a [Preset Value] measure
05:25 Add the measure to a filter card and apply
06:05 Write the DAX for the date calculations to complete our measure
09:00 Do a final test
09:40 Conclusion: Why this may be a better approach than creating bookmarks and assign actions to buttons (but only if you like DAX!)
10:40 Our next videos: building financial models in Excel and Power BI

We run a full range of data analysis and generative AI courses in London and online. See our courses at zomalex.co.uk