Dimension & measure slicers in Power BI with field parameters
It's often useful to make a Power BI dashboard page that analyses various dimensions (e.g. gender, age, country, product, date) but where the user can pick which measure they want broken down by all of those, eg I want to switch between sales broken down by all those, into #customers for all of those into last months sales growth etc.
Or the other way around, various charts have multiple fixed measures and the user can select from a slicer the dimension. Field parameters can do both of these things, and here I explain them with some gotchas worth knowing.
To download example workbooks, enter email here: https://www.xlconsulting-asia.com/soc...
00:00 Introduction
00:57 Measure slicer
03:36 New button slicer
04:13 More visuals from measure picker
04:51 Percentage issues
05:29 Add field/modify field parameter
06:40 Dimension picker
09:31 Chosen dimension without relationships
10:21 Numerical range parameter & Power Query
11:35 Field parameter options
13:16 Show dimension elements in slicer based