Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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.
Solved! Go to Solution.
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
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.
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.
@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.
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.