Forum Discussion
Visual Axes gets double formatted when using calculation groups
dpc_development since OwenAuger already tested it, but I will try to test at my end.
Sorry, I meant to ask whether you know how to detect whether the formatting is done within the axes section or have another alternative, as this is most likely a bug.
Hi dpc_development ,
Please review the content in the following links, hope they can help you.
Dynamic Formatting of Switch Measures in Power BI
Finally! Format $ or % For the Same Measure On the Same Chart (..the Calculation Group bug fixed!)
Best Regards
Hi Anonymous I had gone through those documents/videos, but they don't address the issue I am facing. I am already able to switch measures based on slicer selection and change the format using calculation groups. However, when using the measure in a chart, while the axis numbers show in a short neat manner - in millions or billions, the tooltip still shows in a full absolute manner.
I tried to avoid this by using formats such as '0,,.00', but that makes the visual format the axis numbers twice. So earlier when it showed 800mn on the left, now it shows 0.08mnM.
This seems to be a bug with Power BI.
Hence, I was hoping to find a solution to not format the calculation group when it is plotting numbers on the axes.