Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
My dax forumla is
Outlier = if ([Value] >= [%75] , "Yes" , "NO" )
[%75] is a calculated measure. what i want is if it yes let the color be Red and if it not let the color be Green.
is that even possible?
Solved! Go to Solution.
Hi @SalmanABDul_97 ,
As of my knowledge PBI does not know how to colour code on string values. However, it works just fine if you can provide numbers. So a quick way could be to rewrite your measure like this
OutlierColourCoding = if ([Value] >= [%75] , 1 , 0 )
Then, use it in the conditional formate pane with this settings:
Another way which I personally start to enjoy more and more is to build the colorcodemeasure like this:
OutlierColourCoding = if ([Value] >= [%75] , "green" , "red" )
or you specify the exact color in Hex:
OutlierColourCoding = if ([Value] >= [%75] , "#ff0000" , "#66ff33" )
Then you can choose the measure directly to do all the color coding for you:
It goes a lot quicker to set up your color coding on different spots in your report. However, since you are hardcoding the color per value, you are less flexible if you would like to use different colors in different contexts
Does this help? 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! | |
#proudtobeasuperuser | |
We can make the problem simple with another expression.
When the value is greater than or equal to 75% , return Red . If the value is less than 75% , return Green . Then we can create a measure to return colors .
Outlier = IF([Value]>=0.75,"Red","Green")
Then set conditional formatting for [Value] . Apply measure [Outlier] for [Value] .
The final result is as shown :
I have attached my pbix file , you can refer to it .
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @SalmanABDul_97 ,
As of my knowledge PBI does not know how to colour code on string values. However, it works just fine if you can provide numbers. So a quick way could be to rewrite your measure like this
OutlierColourCoding = if ([Value] >= [%75] , 1 , 0 )
Then, use it in the conditional formate pane with this settings:
Another way which I personally start to enjoy more and more is to build the colorcodemeasure like this:
OutlierColourCoding = if ([Value] >= [%75] , "green" , "red" )
or you specify the exact color in Hex:
OutlierColourCoding = if ([Value] >= [%75] , "#ff0000" , "#66ff33" )
Then you can choose the measure directly to do all the color coding for you:
It goes a lot quicker to set up your color coding on different spots in your report. However, since you are hardcoding the color per value, you are less flexible if you would like to use different colors in different contexts
Does this help? 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! | |
#proudtobeasuperuser | |
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
11 | |
9 | |
6 |