Advanced card conditional formatting with a Measure

[Anonymous]

Hi all,

Sorry for this very simple question but, I have completely ran out of ideas.

I have set up an advanced card with a measure that returns a calculation alongside an up or down arrow (see below).

Total = [Last Month total]-[Count of Cat]&IF([Count of Cat]>0,"↑","↓")

Unfortunately I need to use conditional formatting, but I can’t get it to work with this measure. I am looking for a result of >0 = green & <0 = red. I have set the parameters of the 'conditions' options, but the advanced card does not change.

Looking at the measure, the format appears to be set as "text", and the option to change to "whole number" is greyed out. I suspect this is why the conditional formatting isn’t working? 

Can this format be changed? If not, is there a way to display a number with an arrow in an advanced card with the conditional formation below?

>0 = green

<0 = red

Help as always is massively appreciated,

CF

[amitchandak · Accepted solution]

@Anonymous , refer if these can help

Color Measure - Conditional formatting
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692

[Anonymous]

Thanks everybody, i greatly appreciate all of your contributions.

tex628, i tried your method, but unfortunatley i couldnt get it to work.

In the end, the following link provided by amitchandak worked.

https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692

Thank you all

[tex628]

Yeah, it was my bad. The "&" in the measure automatically converts the format to string. The correct measure should have been just:

Format = IF([Count of Cat]>0,0,1)

But I'm happy you got it sorted! 

/ J

[tex628]

Your measure is returning arrows which are bound to text format. If you create another measure,

Format = [Last Month total]-[Count of Cat]&IF([Count of Cat]>0,0,1)

You can then use this measure to conditionally format your "Total" measure. 



Add you "Total" measure to the visual, apply conditional formatting, change the based on field value from "Total" to "Format".

This should allow you to get the correct colors on your arrows. 

/ J

[Anonymous]

Hi there,

Massive thanks for taking your time to help.

I have created another measure as below:-

Format = [Last Month total]-[Count of Cat]&IF([Count of Cat]>0,0,1)

I have also added my 'total' measure to the visual.

However when adding conditional formatting to the 'based on field' value am unable to select the measure 'format'.

Again it looks like the 'format' measure is bound to text format, as i am unable to change it whole number.

I am obviously doing something very stupid (it's been a long day). Any idea what i am doing wrong here?

Thank yoouuuuu