Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi to All,
I want to create a conditional formating for status ( See below picture for details ) and when I want to create rules it seems only can set for value or numbers in a range. Can any one give me some suggestions on how to do this? For example I want to set color for Production as green and Active for blue, etc.
The format I want in Power BI
Thanks,
Larry
Solved! Go to Solution.
Hi Larry,
Create one calculated column from Status column:
Desire Result:
Hi Larry,
Create one calculated column from Status column:
Desire Result:
Hi Mohityash,
When I'm trying to use your suggested solution, after Switch, my desire table does not appear as an option, only the measures I've created. (see below)
Am I doing something wrong?
Hi @Anonymous ,
Thanks for the help on this issue and it works well for me😊
If Power BI allows us to create rule not only for numbers but also for texts, like in this case and it will be better.
Have a nice day!
Larry
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
73 | |
65 |