How to format and add units to tachometer?

[jacobian8]

Hi, 

I am trying to add units to a tachometer, specifically $/h (Dollars per hour). 

I am able to add just a single $ sign by going into modeling and then format but i need to add the "/h". 

I then tried doing :

FORMAT ([MEASURE], "### $/h")

but that converted it to a string I guess and didnt show any value. All it showed was " (BLANK) ". It did however showed when I chose Card for example. 

So I am wondering if it is possible to add $/h unit to my value in the tachometer visualization. 

Thanks!

[MFelix · Accepted solution]

Hi @jacobian8,

The formats available in Power BI work in different ways on the the several visualizations as you may be aware, when you are using the FORMAT function the and add text to your numbers your data type is setupas text and not as number that is why when you place it on a card it shows values and on the tachometer it shows blanks.

Tachometers can only have number type so when adding text it return blanks. 

One way to overcome this would be to add your measure to the tachometer and then turn off the callout value and add a card on the bottom of the tachometer with the formated measure.

Regards,

MFelix

[jacobian8]

@MFelix

That's exaclty what I figured.

I guess then yes I'll have to use a workaround. 

Thank you!

[jthomson]

Why not set up your measure as just a number then go

DisplayMeasure = concatenate([Measure],"$/h")

[jacobian8]

I tried. 

It still displays (Blank)

Once I do format or concatenate, it turns it into a text. It gets displayed on other visualizations but not tachometer. 

Thanks though