Calculating percentage difference and add it to the visualization.

[ajdm2007]

Hey everyone,

I’ve managed to add several of my metrics to this visualization, but as you can see, I have some labels showing the indicator values for the previous month. What I need is to display the percentage difference between the current indicator value and the label, which shows the value for the previous month, right next to it.

I imagine I need to create another metric to divide those two values, but the problem is I want the percentage to show next to the label, not below it.

Any ideas on how to make that happen or if it’s even possible?

Thanks a lot!

[CKN]

if [a] is your value measure and [b] is the % diff, use 

bb = format([b],"#,##0;(#,##0)") to put [b] into parenthesis, then 

c = COMBINEVALUES("  ",[a],[bb]) to put them side by side. Display [c]
If you want colour changes, play around with the format statement in [bb]

[ajdm2007]

Hello @CKN

Thank you very much for your recommendation, but there is a detail that is in the image but I did not mention it.

If you look at the example you will see that there is a value in red and another in green, so what I did not say is that I need to apply conditional formatting to that percentage, so at some point it can be red and at another time it can be green.

Under this scenario, how could I apply your recommendation? Thanks again.

[Anonymous · Accepted solution]

Hi @ajdm2007 ,

As far as I know, currently Power BI doesn't support us to show different colors for one value by conditional formatting. Here I create a multiple card visual and a new card visual. I think the result of new card visual returned is close to what we need, however all value will return green.

I think you can try to group two visuals. In my sample, I group a multiple card / new card with a card visual. Result is as below.

You can download my sample file to learn more details.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[CKN]

or this if you want to do it with DAX
https://community.fabric.microsoft.com/t5/Desktop/Format-number-color-with-dax/td-p/2432829

[CKN]

This should help you - it's a guide to conditional formatting
https://community.fabric.microsoft.com/t5/Desktop/Show-negative-numbers-as-red-and-in-bracket/td-p/2...

[CKN]

try CONBINEVALUES, using "  " as a delim and your 2 measures as the input expressions. Might need to format your percentage diff measure how you want it to appear first ((), colour etc)

[Eggsforbreaky]

Thanks @CKN you couldnt dumb this down a little for a new user? Thanks