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.
I have 2 visuals I am trying to add conditional formatting to. Visual 2 has conditional formatting based on the Region. The data set has a column called Region, and a calculated column called Color using this formula:
Color = SWITCH(TRUE(),'DPM'[Region]="EMEA","#0061ff",DPM[Region]="APAC","#184489",'DPM'[Region]="Americas","#99c0ff","#979da8")
Conditional formatting is then applied to Visual 2 so now Americas = Color 1 (#99c0ff), APAC = Color 2 (#184489) and EMEA = Color 3 (#0061ff).
Next I want to also apply the same conditional formatting to Visual 1, except that if no Region is selected, it defaults to Color 4 (#979da8). I can't seem to make this work. By default Visual 2 is display either the First or Last in the "Color" column. Any help would be greatly appreciated!
Thanks,
Steve
Steve
Solved! Go to Solution.
Hi @Anonymous ,
To create a measure as below and make the the visual formatted by the filed.
Color = var countr = CALCULATE(COUNT(DPM[Region]),ALLSELECTED(DPM)) var no = IF(countr=3,"#979da8") var re = IF(MAX('DPM'[Region])="EMEA","#0061ff",IF(MAX(DPM[Region])="APAC","#184489",IF(MAX('DPM'[Region])="Americas","#99c0ff"))) return IF(ISFILTERED(DPM[Region]),re,no)
Regards,
Frank
Hi @Anonymous ,
To create a measure as below and make the the visual formatted by the filed.
Color = var countr = CALCULATE(COUNT(DPM[Region]),ALLSELECTED(DPM)) var no = IF(countr=3,"#979da8") var re = IF(MAX('DPM'[Region])="EMEA","#0061ff",IF(MAX(DPM[Region])="APAC","#184489",IF(MAX('DPM'[Region])="Americas","#99c0ff"))) return IF(ISFILTERED(DPM[Region]),re,no)
Regards,
Frank
Brilliant! Works perfectly. Thanks Frank!
One minor update: I modified your calculated measure slightly to use HASONEVALUE instead of ISFILTERED in the IF statement. That way if the user selects multiple regions, the formatting works as intended.
Thanks again.
Color = var countr = CALCULATE(COUNT(DPM[Region]),ALLSELECTED(DPM)) var no = IF(countr=3,"#979da8") var re = IF(MAX('DPM'[Region])="EMEA","#0061ff",IF(MAX(DPM[Region])="APAC","#184489",IF(MAX('DPM'[Region])="Americas","#99c0ff"))) return IF(HASONEVALUE(DPM[Region]),re,no)
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 |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |