The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hi guys,
I'm looking for to create something like this in Power BI
I know that measure values can be switched to rows instead of columns. Please note that optimalization doesn't matter and this needs to be in DAX.
@Chetcork , One way you already suggested Switch Values to Rows in Matrix visual
The second is to create a calculation group and add a category in the calculation group table if that column does not exist
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
User | Count |
---|---|
70 | |
67 | |
63 | |
50 | |
28 |
User | Count |
---|---|
113 | |
77 | |
65 | |
55 | |
43 |