The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
@MFNH You can change the visual interaction to cross-filter. By default it is cross-highlight.
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
Select the visual and under format in the ribbon, select edit interactions and in the visual choose the filter icon
Proud to be a Super User!
Paul on Linkedin.
@MFNH You can change the visual interaction to cross-filter. By default it is cross-highlight.
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