Forum Discussion
Use parameter to set Filters on multiple charts
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?
1 Reply
- amitchandakSuper User
Anonymous , 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-202587d4dedbAnother option explore small mutiples