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.
the above account stage column is a measure and I am trying to add consitional formatting using measure , and New color code is created suing below DAX query
Solved! Go to Solution.
Hi @utkarshshastri ,
If the value you are using for the condittional formatting is a measure you must use the measure itself and not the SELECTEDVALUE try the following:
New color code =
SWITCH([Account stage],
"High Awareness",1,
"Medium Awareness",2,
"Low Awareness",3,
"High conversion",4,
"Medium conversion",5,
"Low conversion",6,
"High Engagement",7,
"Medium Engagement",8,
"Low Engagement",9
)
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @utkarshshastri ,
If the value you are using for the condittional formatting is a measure you must use the measure itself and not the SELECTEDVALUE try the following:
New color code =
SWITCH([Account stage],
"High Awareness",1,
"Medium Awareness",2,
"Low Awareness",3,
"High conversion",4,
"Medium conversion",5,
"Low conversion",6,
"High Engagement",7,
"Medium Engagement",8,
"Low Engagement",9
)
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |