Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Good morning everyone,
maybe the question is trivial but I am new to the environment and I have not been able to find anything on the internet, I hope you will excuse me.
Is it possible to hide all unselected rows in a visual object? That is, how to see only the line AE 2019/04 in the following example instead of the classic behavior reported?
In my report there are several tables to investigate the data; selecting one row on the first the others, as expected, are automatically filtered but when I select one of the surviving rows of the second table this row "disappears" (ends up at the bottom) reappearing, albeit gray, all the rows no longer filtered by click on the first table.
Thanks in advance for your valuable suggestions.
Solved! Go to Solution.
Hi @CrazyDax
So you have few option.
Thanks to everyone for the quick and comprehensive solutions, sorry for my late reply, I was at lunch.
I think I will use the ctrl option proposed by @Mariusz
Maybe it could be an Idea to suggest: add in the visual interaction options the possibility to switch from the lightlight to the auto filter mode (@nandic to select other values it would be enough to click again to display everything and then choose the new value)
Hi @CrazyDax
So you have few option.
@CrazyDax , on the same visual/matrix behavior, will remain the same. But we change on other visual using interactions.
https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions
@CrazyDax , this is natural Power BI behaviour.
You use one list to filter other lists, so it keeps all rows in case you would like to filter by different value.
Alternatives:
1) add slicer for this value so it will automatically filter all lists
2) right click on selected value in list and choose include and then click on it to filter other lists. To return to full list, remove automatically added filter on visualization level
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
74 | |
57 | |
38 | |
33 |
User | Count |
---|---|
71 | |
66 | |
57 | |
49 | |
47 |