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

     

MartynRamsden's avatar
MartynRamsden
Solution Sage
6 years ago

Hi Arnault_ 

 

Unfortunately, the algorithm for automatically calculating the optimal Display Units is somewhat limited.

There's an idea here which relates to having greater control over the 'Display Units'. Be sure to vote for it if you think it would help.

 

In the meantime, all I can suggest is that you try to find a custom visual in the market place which provides what you're looking for.

 

Best regards,

Martyn