Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi everyone,
I need some help with a problem regarding the matrix table visual.
What I need is a visual that ranks my data from high counts to low as you can see in my example. (See screenshot below)
And that shows the percentage values for each row of the filtered data:
In the example in the screenshot above it all looks great because I didn't touch the date slicer yet.
As you can see in the next picture, the percentage values are not correct anymore once I start moving it away from the max:
Also, I have a tooltip wherein I want to put the same visual but here it doesn't work either as it doesn't respond well to the time filter:
It's something that looks so simple, but I've been trying for so long now...
Please be aware on that it's important that the "error xx" fault count rows are ranked from high to low dynamically.
You can find the dataset here:
https://docs.google.com/spreadsheets/d/1u2zBIDsTHsWeMhx9ACDh_cOwdJEDIkwD/edit?usp=sharing&ouid=10978...
And the Power BI file here:
https://drive.google.com/file/d/1gOFk_qjoM4lut2veHG-ltKFl3eOW8OJl/view?usp=sharing
Thanks in advance for your help!
Solved! Go to Solution.
You used a calculated column. These are immutable and do not react to filter changes. Use a measure (either implicit or explicit). See attached for an example of an implicit measure.
User | Count |
---|---|
111 | |
100 | |
98 | |
66 | |
35 |
User | Count |
---|---|
139 | |
138 | |
112 | |
96 | |
52 |