Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
wpf_
Post Prodigy
Post Prodigy

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

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. 

2 ACCEPTED SOLUTIONS
jdbuchanan71
Super User
Super User

@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

View solution in original post

v-diye-msft
Community Support
Community Support

Hi @wpf_ 

 

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

4.gif

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

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

4 REPLIES 4
v-diye-msft
Community Support
Community Support

Hi @wpf_ 

 

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

4.gif

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

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

@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
Super User
Super User

@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

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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!