+ And - sign on cards

[ClaudioL]

Good day,
I am using the type of card "Card with States by OKVIZ" for some dashboards that I create in power bi desktop. In the case of positive values I am showing them in a green color, and in the case of negative values in red. The problem I have is that the company management wants the "+" sign to appear in front of the value in positive values (with green color), since the card appears by default in negative values.
Is there a way to add this "+" sign?
From already thank you very much.

Regards.

[OwenAuger · Accepted solution]

Hi @ClaudioL 

You can do this by providing a custom number format for the measure/column that you are displaying on the visual.

Go to the Model tab, select the colum/measure, and under Formatting choose Format = Custom and enter a format like 

+0;-0;0

(Microsoft documentation page)

I tested this with the Card with States visual and it works fine.

Regards

Owen

[Tahreem24 · Accepted solution]

@ClaudioL ,

Try the below COde:

Measure = IF(SUM(Table[Values])>0,"+","-")

Then use this measure next to your cards. (Adjust it nicely)

And if you want to do color so use the color formattig on above measure.

[OwenAuger · Accepted solution]

Hi @ClaudioL 

You can do this by providing a custom number format for the measure/column that you are displaying on the visual.

Go to the Model tab, select the colum/measure, and under Formatting choose Format = Custom and enter a format like 

+0;-0;0

(Microsoft documentation page)

I tested this with the Card with States visual and it works fine.

Regards

Owen

[DmitryKo]

Custom format option is not available for on-premises, so this solution is not correct.

[OwenAuger]

@DmitryKo Interesting. What do you mean by "on-premises" in this case and specifically when have you observed that this doesn't work?

[DmitryKo]

By "on premises" I mean Power BI Report server. Observed it just now. Power BI Desktop's version for the report server does not provide option for "custom" format for the measure

[OwenAuger]

Interesting...I tried installing the latest version of Power BI Desktop (Report Server version) and was able to change measure format strings, in Measure tools on the ribbon and Model View.

Which version of Power BI Desktop RS are you using, and just confirming you're working in a PBIX containing the dataset?

[DmitryKo]

Please fix your signature, it's terrifying. 2/3 of the post space is taken by signature making it completely unreadable

[DmitryKo]

Version is 2.105.1143.0 (May 2022) which seems to be the latest. Yes, PBIX contains the dataset, it's not offloaded to some tabular storage.