How do i get this visual

[amybirc77]

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.

[Mikelytics · Accepted 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.

[amybirc77]

@Mikelytics thank's a lot!, explained in a very layman way. Thanks

[Mikelytics]

Hi @amybirc77, I am happy to help and appreciate your feedback.

Thank you very much!

[Greg_Deckler]

@amybirc77 I don't know the business rules and there isn't much to go on but the general answer is Conditional formatting.