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
Hi,
I want a matrix like this in my dashboard, but I can't figure out how to achieve it.
| XXX | YYY | ZZZ ---------------------------------------- Total | 832 | 438 | 255 ----------------------------------------
For the column XXX, the equivalent query in Excel would be: COUNTIF(AX = Complete and AY = Done)
Any ideas?
My first try:
With this code, my table has a new column named Total Stats, and tells if the current row is XXX, YYY or ZZZ. The matrix visualization does all the rest.
The only problem of this is that a row can't be XXX and YYY the same time, however, I need it to be so (I want a row to be considered as XXX and YYY for example).
My second try:
I created a new static table using #table(...) with 3 columns XXX, YYY and ZZZ and then display it in the dashboard.
The only problem of this one is the unability to right-click a cell to see the matching records (this is a required feature):
To get your expected result, you must have records like:
Total XXX 832 Total YYY 438 Total ZZZ 255
in your source table.
So you may add a Total column first, then unpivot it to make this Total column appended as rows.
Regards,
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 |
---|---|
114 | |
96 | |
90 | |
79 | |
68 |
User | Count |
---|---|
151 | |
121 | |
111 | |
107 | |
95 |