Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Everyone,
I have a matrix as picture below:
Row: Store
Column: Bucket
Value: Count
I Already have bucket for Good, 1, 2, 3, 4, and 5.
What I am trying to do is add new buckets for:
Bad = 1 + 2 + 3 + 4 + 5
Total = Good + Bad
Is there anyway that I could do this in Power BI
Thanks for your time and help!
@amitchandak thanks for your time
I have a column for bucket,
The issue that I have is this bucket do not have "Bad" and "Total", and I try to add "Bad" and "Total" to the Matrix column. I also have an Detail table, what I would like to do is, if I click to a specific number from the bucket, I can filter the Detail table to show only the data from that bucket.
@Harry_Tran , Bucket is based on the measure?
If yes, do dynamic sgementaion
Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ
if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...
vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
86 | |
85 | |
68 | |
67 | |
63 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |