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
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |