I know you can show totals when hovering on a bar chart. But my totals on my expressions are all divided by millions, so it you hover ot shows 121 for 121435000, so how do I show the full total while hovering?
Not sure I quite understand where you want me to use it. I already use the Dual Function with Month name and Month number combined. Do you mean having a dual with the million rounded and the full value? We have to use it as our Financial Month are June = 1, July = 2, so I am forced to use it for ordering purposes as well, so I can order months by numbers.
My issue is more related to the following
When values are more than a million, I have the Y-axis showing the values in millions, but when I hover it shows the full value
But when the values are less than a million, I still need the Y axis to show the values in millions, for example 250 000 as 0.25 and when hovering it will show 250 000