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,
I have 2 measures MTD and MTD_LY, I want to add a 3rd column that should show if it is good or bad , please see the below sccreen shot (GREEN and RED Arrows), please advice. I looked something similar like
Measure = IF ( MIN ( 'Table1'[Column1] ) < 600, UNICHAR ( 9650 ), UNICHAR ( 128315 ) )
but that is column againt a constant value.
Solved! Go to Solution.
Hi @amybirc77 ,
Additionally to your MTD and MTD_LY measure you would build a delta measure which creates the percentage difference between the first two like:
The format of the measure can be like this:
MTD_LY_DELTA =
var var_MTD = [MTD]
var var_MTD_LY = [MTD_LY]
var var_MRT_LY_Delta = var_MTD - var_MTD_LY
RETURN
DIVIDE(
var_MRT_LY_Delta,
ABS(var_MTD_LY),
BLANK()
)
For this measure typically you do the following formatting.
Then you put all measures into the matrix visual:
For clearer view I put the visual style on minimal
Put on the conditional formatting for the DELTA column and the click on the fomula symbol
now you can set the coloring rule. I configured it to be green for >= 80% and red for < 80%. You can choose in the number type for percentage of number. I prefer to work with number in each case and use decimal numbers to represent the percentages.
after clikcing ok, the coloring is there
now you can also create icons
Result after ok
you can do some more stuff but this should give you a good overview to go on.
You can find more information here
Apply conditional table formatting in Power BI - Power BI | Microsoft Learn
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
Hi @amybirc77 ,
Additionally to your MTD and MTD_LY measure you would build a delta measure which creates the percentage difference between the first two like:
The format of the measure can be like this:
MTD_LY_DELTA =
var var_MTD = [MTD]
var var_MTD_LY = [MTD_LY]
var var_MRT_LY_Delta = var_MTD - var_MTD_LY
RETURN
DIVIDE(
var_MRT_LY_Delta,
ABS(var_MTD_LY),
BLANK()
)
For this measure typically you do the following formatting.
Then you put all measures into the matrix visual:
For clearer view I put the visual style on minimal
Put on the conditional formatting for the DELTA column and the click on the fomula symbol
now you can set the coloring rule. I configured it to be green for >= 80% and red for < 80%. You can choose in the number type for percentage of number. I prefer to work with number in each case and use decimal numbers to represent the percentages.
after clikcing ok, the coloring is there
now you can also create icons
Result after ok
you can do some more stuff but this should give you a good overview to go on.
You can find more information here
Apply conditional table formatting in Power BI - Power BI | Microsoft Learn
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
Hi @amybirc77, I am happy to help and appreciate your feedback.
Thank you very much!
@amybirc77 I don't know the business rules and there isn't much to go on but the general answer is Conditional formatting.
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |