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 am utilizing a SQL Direct Query to pull my information into Power BI. I am presenting the information required, however the customer would like to color code the results (red for down and yellow for unhealthy). The dashboard is reporting both the down and unhealthy objects being reported in SCOM.
1. Is this possible?
2. Any other creative ideas on how color code these results?
Thanks,
Chad Myers
Power BI Noob
Solved! Go to Solution.
1. Is not possible applied conditional format to text only values.
2. A solution maybe is:
Create a calculated column with numbers according to your status:
Color = SWITCH(Tabla1[STATUS];"DOWN";1;"UNHEALTHY";2;3)
3: Next in a table:
Put Display name and Average of Color
4. With conditional format select colors to 1;2 and 3.
5. Adjust the width of colum to hide the headers.
1. Is not possible applied conditional format to text only values.
2. A solution maybe is:
Create a calculated column with numbers according to your status:
Color = SWITCH(Tabla1[STATUS];"DOWN";1;"UNHEALTHY";2;3)
3: Next in a table:
Put Display name and Average of Color
4. With conditional format select colors to 1;2 and 3.
5. Adjust the width of colum to hide the headers.
Speaking of conditional formatting
@KHorseman and @Vvelarde have you Voted for this Idea (it seems the PBI folks combined/consolidated 2 of the Ideas)
Hopefully that's a good sign - for implementation soon
Anyway we REALLY need to be able to build KPIs inside the PBI Desktop (not build first in PowerPivot and then import)
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 | |
98 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |