Forum Discussion
Hide data based on slicer
Hi.
Is it possible to hide unhide rows in a matrix based on a slicer? I have a matrix showing an article and the components for this article. As we have multiple sales organisations, we would like to show the local article number for the components. Instead of showing 6 local number, we would like to have a filter, so only select local number is shown.
Table 1 includes all our articles and their bill of material. This means that the components are used multiple times. Our master data is table 2. Table 3 can either be one row per article and then one column per country for local no. Or 6 rows per article with one row per article/local no. What ever works best.
In our matrix we would like t
Hi HEW
I'm afraid there's no quick way to achieve this requirement, currently, it is not supported to hide/show row conditionally based on slicer. like the above suggestion, the bookmark would be the best workaround.
3 Replies
- MariuszCommunity Champion
Hi HEW
You can design all the Matrixes as you want them and use buttons and bookmarks to switch the views as in the video below.
https://www.youtube.com/watch?v=z9jdkyyE3WU
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn - amitchandakSuper User
HEW , Book mark should help, refer
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks
https://www.youtube.com/watch?v=PTOJC42rg_k
https://www.youtube.com/watch?v=z9jdkyyE3WU
https://www.youtube.com/watch?v=5TaZQFc-t58
https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=024bfbef-72e7-48a7-9be5-92dba49a4091&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer - v-diye-msftCommunity Support
Hi HEW
I'm afraid there's no quick way to achieve this requirement, currently, it is not supported to hide/show row conditionally based on slicer. like the above suggestion, the bookmark would be the best workaround.