Forum Discussion
Auto display units not working when no decimals
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.
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.
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.
v-qiuyu-msftCommunity Support
Hi Anonymous,
Based on my test, in a KPI visual, the currency field contains decimal will display in corresponding units automatically. While the currency field without decimal will display as a whole value without any unit. But as there is a OOTB feature called Display Units in KPI visuals, we can always display values in prefer units by setting this property. I don't think it's a matter to set this property as a prefer value.
In addition, in a table or matrix visual, there is no buit-in property which is the same as the "Display Units" in KPI visuals. For this issue, you can post a idea in Power Ideas forum.
If you have any question, please feel free to ask.
Best Regards,
Qiuyun YuI think I'll open a bug then. It doesn't make sense that the visual is showing a whole number when there's no decimals. I can't either choose manually the display unit since I have a report that can show sales of the total organization (in billions) as well as sales of a single site (in thousands).
As for the table visual, it was only an example. I don't want decimals anywhere (other visuals, tooltips, etc.). While it would be great to have a "number of decimals shown" property in the table and matrix visual, it would not fix my problem.
Currently, I'm creating my measures twice. One with decimals for the KPI and other similar visuals and one without decimals for the others. Kind of stupid if you ask me.