Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I am trying to do something slightly unusual with a field parameter. I have a situation where my query has the following fields:
Sales, Year, Quarter, Region, Category, Business Unit
I want to plot four bar charts with the Y-axis=Sales, X-axis=Quarter and Legend=Year. For the filters on each chart, I would then like to enable the user to select a field parameter from Region, Category or Business Unit - this parameter would be used to filter each of the charts with the first four values of the selected field parameter.
For example, Region has four possible values (East, North, South and West). If I select Region as the parameter I would want to the first chart to be filtered for Region = East, the second to be filtered for Region = North, then Region = South and Region = West.
Is there a way I can achieve this?
@bluebottle81 , we have got have the feature of dynamic slicers using field parameters
Make the slicer of values a single select and try
Power BI- Create dynamic slicers using field parameters: https://youtu.be/H2ZxWaHAJZQ
https://medium.com/@amitchandak/power-bi-power-bi-create-dynamic-slicers-using-field-parameters-2025...
Another option explore small mutiples
User | Count |
---|---|
84 | |
76 | |
74 | |
48 | |
39 |
User | Count |
---|---|
114 | |
56 | |
51 | |
42 | |
42 |