Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Team,
I have created an measure that takes Max of Color and I put that in the matrix.
Measure = Max(Table1[Color])
This is what data looks like:
Company | Measure |
C1 | 0_Green |
C2 | 3_Red |
C3 | 2_Yellow |
C4 | 1_Blue |
I have added this measure in my matrix. How do i background color on this measure considering I'm taking a max?
I tried creating a mesaure:
Measure 2: Var c = SelectedValue() Return if c = 0_Green, "Green", False, but it wont let me select Measure
I would like 0_Green to have Green etc.
Solved! Go to Solution.
You can reference your measure? Are you confused because I've named my measure 'Measure' and you already have a measure called 'Measure'?
Here, try this as measure. Then select this measure BGColor in the Conditional Formatting dialogue.
BGColor =
VAR col = [Measure]
RETURN
IF(col = "3_red", "Red",
IF(col = "0_green", "Green",
IF(col = "2_yellow", "Yellow",
IF(col = "1_blue", "Blue", "White"))))
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Kudo's are welcome 🙂
Proud to be a Super User!
I've recreated your table in PowerBI and created the following measure:
Measure =
VAR col = SELECTEDVALUE('Table'[Color], "Grey")
RETURN
IF(col = "3_red", "Red",
IF(col = "0_green", "Green",
IF(col = "2_yellow", "Yellow",
IF(col = "1_blue", "Blue", col))))
Then I put everything in a table visual, resulting in the following table:
I was able to set the conditional formatting of any column, based on a value (of Measure, in this case):
Note that the measure could be a lot easier if all your values are in the format of x_color, by taking the substring rather then a long nested IF statement. If there could be multiple numbers before the underscore, than this wouldn't work but that's another problem then 😉
Measure 2 =
VAR col = SELECTEDVALUE('Table'[Color], "0_white")
RETURN
RIGHT(col, (LEN(col)-2))
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Kudo's are welcome 🙂
Proud to be a Super User!
@JarroVGIT How do I keep my Max Measure? I understand what you are tying to do. But I need to keep that Max Measure on my Matrix then apply the color on top of it. I have a lot of companies.
You can reference your measure? Are you confused because I've named my measure 'Measure' and you already have a measure called 'Measure'?
Here, try this as measure. Then select this measure BGColor in the Conditional Formatting dialogue.
BGColor =
VAR col = [Measure]
RETURN
IF(col = "3_red", "Red",
IF(col = "0_green", "Green",
IF(col = "2_yellow", "Yellow",
IF(col = "1_blue", "Blue", "White"))))
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Kudo's are welcome 🙂
Proud to be a Super User!
@DJ I messed it up. I selected the column. THanks for help. That actually fixed my issue.
Create a numeric measure and then do a conditional formatting on the desired column using that measure:
Color measure =
Switch(
[Company] ;
"C1" ; 1 ;
"C2" ; 2 ;
"C3" ; 3 ;
"C4" ; 4
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |