Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have created a calculated column in Power Bi Desktop in Table Visualization. The cell values in the columns contain Black, Blue and Red. I want to colour the cells based on these cell values present in the calculated column. I want Blue cell in the table to have Conditional Formating-> Background as Blue colour background and Red cell fields as Red colour background. How to solve this issue?
Solved! Go to Solution.
Create a measure like this:
color = MAXX(Table1,IF(Table1[Product]="Green",1,IF(Table1[Product]="Yellow",2)))
Then apply conditional format in your column using this measure:
Thanks
Raj
I have created a calculated column in Power Bi Desktop in Table Visualization. The cell values in the columns contain Black, Blue and Red. I want to colour the cells based on these cell values present in the calculated column.
I want Blue cell in the table to have Conditional Formating-> Background as Blue colour background and Red cell fields as Red colour background.
How to solve this issue?
Create a measure like this:
color = MAXX(Table1,IF(Table1[Product]="Green",1,IF(Table1[Product]="Yellow",2)))
Then apply conditional format in your column using this measure:
Thanks
Raj
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |