Forum Discussion
Visualising table cells that pass certain criteria
Hello,
I'm trying to add a functionality to a table I have in powerBI (as included in the photo) where we have a category of risk in the rows, different sections of the organisation in the columns and a count of the risks in the cells.
Each risk category has different levels where we have different levels of acceptability. If for example the count of risks in e.g. risk category 1 > 5 I'd like the cell to be red, if it's < 5 yet > 3 yellow etc. And there are different levels per row, how can I implement this functionality?
Kind regards
Hi Anonymous
You can create a measure for conditional formatting the matrix value field. Not sure what's your data table structure, so I create a simple demo. You can modify the measure accordingly.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
2 Replies
AgataJHelper II
Hi Anonymous ,
Try to set up conditional formatting to each column. Right-click on the column name in Build panel and you will Conditional Formatting options.
Kind regards,
Agata
If this post helps, then please consider to accept it as the solution to help the other members find it more quickly.
Hi Anonymous
You can create a measure for conditional formatting the matrix value field. Not sure what's your data table structure, so I create a simple demo. You can modify the measure accordingly.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!