First, I'm using a SSAS MD live connection. My users don't want to see the decimals in their measures. Simple thing, I just removed the decimals in the format string of SSAS.
But I'm having a problem with some visuals when doing that. For visuals like the KPI, if there's no decimals and you set the display units to auto, it is ignored so you see the full number.
As an example, if you have total sales of $132,456,789, the KPI should display $132M since the display units is set to Auto but it's displaying $132,456,789. It's woring if there is decimals in the sales measure.
I know I can manually set the display units but it's problematic since I can filter down to the store in my report and setting to Millions as an example would show 0. I really need to put the display units to Auto but why is it ignored when there's no decimals in the measure?
