Show/Hide Column based on slicer for Week & Month

[Anonymous]

Hi!

I am using matrix to show my data and I want use slicer when I select month the value will show like the image below

and If I select by week it will show like the image below

This is my matrix data

Therefore the value will be group either by month or week. 

Is there any way I can do that?

I want to show the column in the matrix either by week or by month?

[Mohammad_Refaei]

Rather than trying to work on the matrix column dynamicity, you can easily create bookmarks to show/hide 2 sets of matrix visuals.

Please check this sample file.

[aj1973]

@Mohammad_Refaei 

Nice work

[Anonymous]

Hi ! Is there any way for me to keep all the filter when doing this bookmark? As I unclick  for the data! The month change back to week or vice versa

[aj1973]

Hi @Anonymous 

Not sure what are you talking about but you can choose your filters on the page and then Update it here

[Anonymous]

I already made two boorkmark for this but when I change my column back to Week both of the boomark will change to week. So I cannot get one for month and one for week

[aj1973 · Accepted solution]

Did you use visual selection?

[Anonymous]

I have 6 different matrix in one tab .Does it mean I need to made another tab and hide the tab based on week and month? Do we have that option in bookmarks?

[aj1973]

Honestly I can't really tell what you need to see and don't...You either do modifications to your pages until you get what you want(that's a way to learn how to use bookmarks) or you share your Pbix file and then I can help you out.

[Anonymous]

Its okay! 

Thank you very much for your help!

I did the overlapping matrix to each other and did the bookmark visual Selection. 

Then toggle it !

Thank you very much again! 

[aj1973]

Welcome

[Mohammad_Refaei]

Thank you 🙂