Forum Discussion

Shimon_Amir's avatar
Shimon_Amir
New Member
3 years ago
Solved

Convert data to millions (Visual Only)

Dear Community,

 

I have data that are actually divided into 1,000 in the source systems. So, in other words, "1" in my data reflects "1,000".

The issue is that when using visuals, power bi treats my data as it is when it should treat differently.

 

Is there any way to custom format the results only on the visuals without modifying the actual data (I know I can multiply the raw data by 1,000, but I want to avoid it for different reasons)?  

for example - in KPI or Graph, instead of seeing "3.47M" I will see "3.47B"

 

Thanks in advance.

Need Help
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi Shimon_Amir 

    you can try to write a measure to multiply the column by 1000 and plot with the measure instead. 

    e.g. initially you plot the sum of a value column, now you plot a measure like:

    measure = SUM(TableName[Value])*1000

2 Replies

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

    hi Shimon_Amir 

    you can try to write a measure to multiply the column by 1000 and plot with the measure instead. 

    e.g. initially you plot the sum of a value column, now you plot a measure like:

    measure = SUM(TableName[Value])*1000

  • ppm1's avatar
    ppm1
    Solution Sage
    3 years ago

    You can use the following custom format string on your column and/or measures.

     

    #,#0,,.000B

     

    Pat