Is there a visual that can choose to display a specific table or matrix?

[wpf_]

Is it possible to have one table or matrix to show data based on different group by fields?  

For example, I would want a visual to filter by location, one table or matrix would show this data.  Then i would change to filter by date, and the same table or matrix would show the data now grouped by date, and etc.  I don't want to have different tables or matrixes for each. Thanks. 

[jdbuchanan71 · Accepted solution]

@wpf_ 

You can accomplish this using bookmarks to switch the grouping column.  Take a look at this thread with a solution to a similar quesiton.

https://community.powerbi.com/t5/Desktop/Doubling-up-on-bookmarks/m-p/769112#M370614

[v-diye-msft · Accepted solution]

Hi @wpf_ 

Let me know if you'd like to get below one:

I copied the table and make a unpivot, pbix attached for your reference.

[wpf_]

@v-diye-msft , Thanks for your help with creating it for me. I took a look and although I think this can work, the bookmarks might be a better fit for me at this time. Thanks again. 

[jdbuchanan71 · Accepted solution]

@wpf_ 

You can accomplish this using bookmarks to switch the grouping column.  Take a look at this thread with a solution to a similar quesiton.

https://community.powerbi.com/t5/Desktop/Doubling-up-on-bookmarks/m-p/769112#M370614

[wpf_]

@jdbuchanan71 Thanks, I think bookmarking is what can work for me.  I will take a deeper look into. Thanks.