Remove $ symbol from the axis of column and clustered chart in power bi desktop

[divyanshug15]

Hii

While creating line and column clustered chart in power bi i am facing issue for formatting axis of the chart. Please the screenshot in which i want to remove $ symbol from the axis and keeping dollar sign on tooltip.

Can not used custom tooltip because i want single field in tooltip both for column and line.

Thanks in adavnce.

[mark_endicott · Accepted solution]

Just hide the Secondary y-axis, by turning "Values" off. See below:

Seeing as your y-axis is on the same scale, and has no $ sign, it can act as the axis for both sides of the chart.

If this works, please accept as the solution, it helps others with the same challenge. 

[mark_endicott]

@divyanshug15 - did we resolve your issue? If we did, please select the appropriate solution, it helps with visibility for others and for SuperUsers to keep their status! Thanks!

[Anonymous · Accepted solution]

Hi @divyanshug15 ,

This is unsupported. However, as a workaround, you can use the custom tooltip page instead of the normal tooltips. You can create another column, formatted without a ‘$' sign, and then use it as a field for the tooltip page.

As you can see, there is not the '$' sign displaying in the tooltip page. 

Create report tooltip pages in Power BI - Power BI | Microsoft Learn

Best Regards,

Stephen Tao

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

[Uzi2019]

Hi @divyanshug15 

You can create one more mesaure for $amount.

for example: data type
Amount = whole Number
Amount1= Currency

Measure (Amount1)= Sum ('Table'[Amount])

set this to currency symbol and set your  exts amount to whole number.

As you can see in screenshot. on Secondary Y axis my numbers are without currency but When I hover on chart it displays currency value.

you have to add currency amount to the tooltip. so that when you hover it display both the Y axis values together..

I hope I answered your query!

[divyanshug15]

When you hover on line i dont think get the desired result. Please Check and Thanks.

[Uzi2019]

Hi @divyanshug15 

Check this.

[divyanshug15]

Please hover on line i dont think you will get the desired result.

[mark_endicott]

@divyanshug15 - You wont, because the Line tooltip will always reflect the value that is being given by your Axis, and your Axis has had the sybol removed. 

Your safest bet is to question the requirement of displaying both Axis seeing as from your screenshot, it is unecessary chart junk: https://en.wikipedia.org/wiki/Chartjunk 

[Uzi2019]

Hi @divyanshug15 

Unfortunetly No, You cant have one column which represents on Y axis as a whole number (data type) but on Tooltip it shoud be display as a $ currency data type. 

You must have to add tooltip or create custom tooltip for you solution.

I hope I answered your question!

[divyanshug15]

Thanks for trying @Uzi2019 

[divyanshug15]

Thanks @mark_endicott but the requirement is to show both the axis.

[mark_endicott · Accepted solution]

Just hide the Secondary y-axis, by turning "Values" off. See below:

Seeing as your y-axis is on the same scale, and has no $ sign, it can act as the axis for both sides of the chart.

If this works, please accept as the solution, it helps others with the same challenge.