Hide data based on slicer

[HEW]

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

[v-diye-msft · Accepted solution]

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. 

[amitchandak]

@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-...

[Mariusz]

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