Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I have a Matrix visual that displays different Software in installation states. If 100% is installed I would like for the row to be removed from the visual, making it easier to focus on the problems. The percentage is calculated by the visual, Show Value as -> Percent of Row Total
Example Matrix of what I have:
Failed | Installed | Not installed | Pending | |
Software A | 100% | |||
Software B | 3.77% | 90.57% | 5.66% | |
Software C | 0.48% | 97.58 | 1.93% | |
Software D | 100% |
Example Matrix of what I would like:
Failed | Installed | Not installed | Pending | |
Software B | 3.77% | 90.57% | 5.66% | |
Software C | 0.48% | 97.58 | 1.93% |
Is it possible?
Solved! Go to Solution.
Share sample pbix file to help you.
Sorry I did not see this answer.
https://drive.google.com/file/d/1tD_vZr4AjD0VKGlAKLd9lnUiBaZsAHHA/view?usp=sharing
I just want ro remove/hide the rows where 100% is installed.
you can write like this
IF( [Installed] >= 1, BLANK(),[Installed] )
I figured out that I need to do a measure, I should have known that. 😉
But it comes up with an error, "The value for 'installed' cannot be determined. Either the column doesn't exist, or there is no current row for this column."
Does this error occur because my Matrix comes from the values of "installState" and not from it's own column.
Where excatly would I write that? I'm not that well into Power BI (but trying to get there).
User | Count |
---|---|
89 | |
75 | |
69 | |
65 | |
58 |
User | Count |
---|---|
103 | |
94 | |
75 | |
61 | |
58 |