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 All,
How Can change Background Colors base on Char String's in one column
I want Look Background like this,
Bangladesh - Red Color
Barbados - Blue Color
Brazil - back Color
Thanks & Regards
Bobbala Naveen Venkatesh
Solved! Go to Solution.
Hi @Anonymous ,
We can create a meausre as below and make the background color based on the measure.
Measure = SWITCH ( TRUE (), MAX ( Table1[Countryname] ) = "Bangladesh", "#FF000D", MAX ( Table1[Countryname] ) = "Barbados", "#0018FF", MAX ( Table1[Countryname] ) = "Brazil", "#000000" )
Pbix as attached.
Regards,
Frank
Hi @Anonymous ,
We can create a meausre as below and make the background color based on the measure.
Measure = SWITCH ( TRUE (), MAX ( Table1[Countryname] ) = "Bangladesh", "#FF000D", MAX ( Table1[Countryname] ) = "Barbados", "#0018FF", MAX ( Table1[Countryname] ) = "Brazil", "#000000" )
Pbix as attached.
Regards,
Frank
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 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |