Add pre-set filter buttons to a Power BI dashboard - a DAX approach скачать в хорошем качестве

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