copykai's avatar
copykai
Icon for Resolver I rankResolver I
7 years ago
Status:
Accepted

KPI Visual not auto displaying the units correctly

Hi,

 

When you choose the auto on the display units in the indicator for the KPI visual, you it doesn't do anything to the indicator. You would have to choose thousands/millions manually which ruins the report, since the users are able to see data for days, months, years and so on.

 

With AutoWith Millions

 

Is there a solution or is it a bug?

I found a similar post with the same issue:
https://community.powerbi.com/t5/Issues/KPI-Visual-Indicator-Display-Units-Auto-not-working/idi-p/635905?advanced=false&collapse_discussion=true&filter=location&location=category:PBI_Comm_Issues&q=kpi%20display%20units%20auto&search_type=thread

It is marked as solved which I don't think it is.

Custom Visuals

9 Comments

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi copykai ,

     

    I have reported this problem internally, CRI: 115940680. Would update here once I get any response.

     

    Best regards,

    Yuliana Gu

  • copykai's avatar
    copykai
    Icon for Resolver I rankResolver I
    7 years ago

    Hi,
    I discovered that this only occurs when the data type is Whole Number.
    If Decimal is chosen then it will display the units correctly.

  • MaKH's avatar
    MaKH
    Regular Visitor
    7 years ago

    Hi, if decimal is chosen with 2 decimals (or more) and thousand-separator, it is shown correctly, but if you decrease to 1 or 0 decimals it is not working (from my experience). 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    MaKHThis fixed the issue for me as well. Thanks!

  • jochenj's avatar
    jochenj
    Icon for Advocate III rankAdvocate III
    6 years ago

    run into the issue with latest December 2019 release , this is still an issue 😞

    DisplayUnits="Auto" does only work if measure is formated with 2digit decimal places, all other combinations (Measure Datatype/format "Whole number" or "deciimal" with other then 2digits) kill the automatic scaling, this is really a showstopper for usage

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Is this issue resolved? I still see "Auto" option is not working in KPI visual. It shows the same value as "None". 

  • sfog's avatar
    sfog
    Icon for Advocate II rankAdvocate II
    5 years ago

    This seems to be partially solved. If you add a currency ($ for instance) both the Indicator and Goal will automatically format the number to M/K etc. However, if you do not have a currency assigned in Column Tools >> 'Display the values in this column as currency' - then the Auto setting does not work. 

     

    If you do notwant to use a currency indicator, you can sovle this manually by creating a Dax measure and manually formatting it as #,##0M if the value is greter than 1,000,000.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    v-yulgu-msft: This bug is soon to be 6 years old. It should be a simple fix. What is the holdup?

     

Completed Ideas