Forum Discussion
Value format in Chart
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
Hi Arnault_ ,
I have tested the scenario in my environment but could not find an effective solution to meet your requirement. When you change the size of the chart, you cannot meet display units and drill down level at the same time.
Perhaps you can submit the requirement to ideas and add your comments there to make this feature coming sooner: https://ideas.powerbi.com/forums/265200-power-bi-ideas
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
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
- Thanks for coming back and posting your workaround!
