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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.