Forum Discussion
How to hide unselected rows in a visualization table
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.
Hi CrazyDax
So you have few option.
- use slicers - slicres do not clear the selection automaticly when making selections on other visuals
- use crtl - when selecting datapoints on multiple visulas, this will sipli add thous to the filter context.
- right click and include the datapoint selection ( you will have to cleare those in the filter pane if you wish to change a selection )
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn
4 Replies
Hi CrazyDax
So you have few option.
- use slicers - slicres do not clear the selection automaticly when making selections on other visuals
- use crtl - when selecting datapoints on multiple visulas, this will sipli add thous to the filter context.
- right click and include the datapoint selection ( you will have to cleare those in the filter pane if you wish to change a selection )
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedInCrazyDax , 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 levelCrazyDax , 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
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)
