Forum Discussion
Auto display units not working when no decimals
Resident RockstarHi 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....
Here's a screenshot of the KPI as I wanted it. Basically using display units = auto so it shows in millions, thousands or others.
I want to show the same Sales amount in another visual like a table but without any decimals.
If I put no decimals in the format string of SSAS, here's what I have. The table is fine but the KPI is discarding the display units set to auto. It's behaving the same way as if it was set to None.
- Baskar
Hi Eric,
Pls try this one,
1. Go to ht KPI Format option. there u can find the first option like "Indicator" Check and choose Display format as "Auto".
and keep the Decimal as blank.