Forum Discussion
Auto display units not working when no decimals
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?
11 Replies
- Baskar
Resident Rockstar
Hi Eric,
When u set auto it will show like this only, I suggest u select "none" it will work am sure. try this.
If u want to remove decimal permently for the measure , click them measure and choose the "Modelling Ribbon"
there you can set decimal digits = 0,
let me know if not working or am wrong
Already tried it and it's not working. I want auto in "display units" which basically automatically show in millions, thounsands and so on based on the value. I cannot change the format in the modeling ribbon since I'm using SSAS MD live.
When setting the format to "$#,##0;($#,##0)", the auto display units behave as the non display units.
When setting the format to "$#,##0.00;($#,##0.00)", the auto display units behave correctly. But since I don't want to show decimals when using this measure in other parts of the reports, I'm screwed. The only way I found right now is to create the measure twice in SSAS in different format string.
- Baskar
yes you are correct.. i agree with your point.
can u please clarify me once again, sorry if no sense in this question.
do u want decimal in Card.
but don't want in other like in bar chart....
