Forum Discussion
Create a colour visual rule
I am new to PowerBi so please let me know if I need to explain further what I mean.
I have created a table that returns from a SS if a rows cell is blank or not. I want to use this as a quick and easy visual using a traffic light system e.g. if all 3 columns return "Yes" I would like this to be highlighted green, if all "No" return Red and if mixed return Yellow/Orange.
The data is coming from a live SS on my companies SharePoint. I have used the below to create the Yes and No
1 Site Owner Exists = VAR MaxBlank = 1
RETURN
IF (
CALCULATE (
COUNTBLANK ( [Site Owner (1):] )
) >= MaxBlank,
"No",
"Yes"
)
Hi LockMary
Please try this:
First of all, I create a set of sample data:
Then add a measure:
Color = VAR _currentColumn1 = SELECTEDVALUE ( Data[Column1] ) VAR _currentColumn2 = SELECTEDVALUE ( Data[Column2] ) VAR _currentColumn3 = SELECTEDVALUE ( Data[Column3] ) RETURN IF ( _currentColumn1 = "Yes" && _currentColumn2 = "Yes" && _currentColumn3 = "Yes", "Green", IF ( _currentColumn1 = "No" && _currentColumn2 = "No" && _currentColumn3 = "No", "Red", "Yellow" ) )Then add a table visual and right click the field, select the conditional formatting > font color
Select Field value from the Format style, and choose the color measure in the next checkbox.
The result is as follow:
Best Regards,
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
If you give your DAX the hex code for the color you want, you can use the measure directly for the conditional formatting rule. E.g. you could output the color shade of red/green from your if-statement. Here's another post on it with more info:
Hi LockMary
Please try this:
First of all, I create a set of sample data:
Then add a measure:
Color = VAR _currentColumn1 = SELECTEDVALUE ( Data[Column1] ) VAR _currentColumn2 = SELECTEDVALUE ( Data[Column2] ) VAR _currentColumn3 = SELECTEDVALUE ( Data[Column3] ) RETURN IF ( _currentColumn1 = "Yes" && _currentColumn2 = "Yes" && _currentColumn3 = "Yes", "Green", IF ( _currentColumn1 = "No" && _currentColumn2 = "No" && _currentColumn3 = "No", "Red", "Yellow" ) )Then add a table visual and right click the field, select the conditional formatting > font color
Select Field value from the Format style, and choose the color measure in the next checkbox.
The result is as follow:
Best Regards,
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hiya, thank you for this. I thought this would be the solution I was looking for however, I have created measures for my existng columns to return Yes if a contact is listed, and No if a contact is not listed (the idea is to highlight/traffic light the need for a contat to be listed). This means I am unable to use the original columns in the new measure you have listed above and I am unable to reference a measure within a measure.
Could I add new columns that would return the Yes/No values and use the measure you have suggested on that ?
