Forum Discussion
Conditional Formatting Power BI Matrix
- 2 years ago
Try this ...
Create a measure ...
RAG = IF( NOT ISFILTERED(yourdata[Market]) && [Growth] > 0.0193, "Green")Delete your visual to remove all previous conditional formating and start again.
In your visual click on Growth, Conditional formating, Font colour
#
Select Format style = Field value
Apply to = Values and totals
Based on = RAG
Thanks for the clear description of the problem with example data. I wish everyone did that!
Remember we are unpaid volunteers, and you have got free expert help which took a lot of effort,
This solution works and does exactly what you asked.
So please quickly click the [accept as solution] and the thumbs up button to leave kudos.One question per ticket please. If you need to change or extend your request then please raise a new ticket.
You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you !
If you quote speedramps in your next tickets then I will then receive an automatic notification, and will be delighted to help you again.
Please now click the [accept as solution] and the thumbs up button. Thank you.
Try this ...
Create a measure ...
RAG =
IF( NOT ISFILTERED(yourdata[Market])
&& [Growth] > 0.0193, "Green")
Delete your visual to remove all previous conditional formating and start again.
In your visual click on Growth, Conditional formating, Font colour
#
Select Format style = Field value
Apply to = Values and totals
Based on = RAG
Thanks for the clear description of the problem with example data. I wish everyone did that!
Remember we are unpaid volunteers, and you have got free expert help which took a lot of effort,
This solution works and does exactly what you asked.
So please quickly click the [accept as solution] and the thumbs up button to leave kudos.
One question per ticket please. If you need to change or extend your request then please raise a new ticket.
You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you !
If you quote speedramps in your next tickets then I will then receive an automatic notification, and will be delighted to help you again.
Please now click the [accept as solution] and the thumbs up button. Thank you.