Forum Discussion
Matrix visual: remove rows where status equal 100%
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?
6 Replies
you can write like this
IF( [Installed] >= 1, BLANK(),[Installed] )Where excatly would I write that? I'm not that well into Power BI (but trying to get there).
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.
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.
