Forum Discussion
How to only visualise selected element from the other graph
Dear All,
I am new to PowerBI, I would like to only visualise from a subset of data.
For example, I have several columns with a list of countries, states, districts and then scores. I have three boxplots:
(i) Countries vs scores,
(ii) States vs scores, and
(iii) District vs scores
Usually, If I choose a country e.g. Malaysia in the first graphs. Other states and districts that are not in Malaysia will be grey out and highlighted the Malaysian. Is there a way to just view the States District in Malaysia without the greyed?
Thank you
MFNH You can change the visual interaction to cross-filter. By default it is cross-highlight.
- select Format > Edit interactions.
2. Then select the visual, you will see a filter icon near to other visual. Click on that to activate the cross-filter interaction.
Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
2 Replies
- nandukrishnavs
Community Champion
MFNH You can change the visual interaction to cross-filter. By default it is cross-highlight.
- select Format > Edit interactions.
2. Then select the visual, you will see a filter icon near to other visual. Click on that to activate the cross-filter interaction.
Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
PaulDBrownSelect the visual and under format in the ribbon, select edit interactions and in the visual choose the filter icon