Forum Discussion

Arnault_'s avatar
Arnault_
Resolver III
6 years ago
Solved

Value format in Chart

Hi All, I am trying to fix an issue relating to the auto formatting feature available in Power BI visuals. Here is below a picture to illustrate my problem. The two following charts are exactly the...
Need Help
  • Arnault_'s avatar
    Arnault_
    6 years ago

    Hi v-yingjl  and MartynRamsden ,

    Thank you for your answers. I finally found a workaround. I am not sure it will work in all cases.

    I went to the formatting option of the X-Axis (it can Y-axis depending on the chart you use - mine was an horizontal bar chart) and set the minimum value ("Start") to 0 instead of "Auto". I was thinking to change the maximum value as well but it was not necessary and the label automatically changed, delivering the expected outpout. Now it seems, I can drill down and the label changes without displaying the ugly 0.0M.

    Hope this will help other users to solve the issue.

    Thanks

     

Arnault_'s avatar
Arnault_
Resolver III
6 years ago

Hi v-yingjl  and MartynRamsden ,

Thank you for your answers. I finally found a workaround. I am not sure it will work in all cases.

I went to the formatting option of the X-Axis (it can Y-axis depending on the chart you use - mine was an horizontal bar chart) and set the minimum value ("Start") to 0 instead of "Auto". I was thinking to change the maximum value as well but it was not necessary and the label automatically changed, delivering the expected outpout. Now it seems, I can drill down and the label changes without displaying the ugly 0.0M.

Hope this will help other users to solve the issue.

Thanks

 

MartynRamsden's avatar
MartynRamsden
Solution Sage
6 years ago
Thanks for coming back and posting your workaround!