Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Power BI Format Question

Hi everyone,   I have a table like the following one:   Now I would like to remove the currency symbols here in the "Report" section, but without affecting the "Data" section. The problem ...
Need Help
  • Dinesh_Suranga's avatar
    Dinesh_Suranga
    3 years ago

    Anonymous 

    Hi,

    If you want to keep your Data section coulums as currency and if you need to change columns in report as decimal then best option is creating mesures.

    Thank you.

Dinesh_Suranga's avatar
Dinesh_Suranga
Continued Contributor
3 years ago

Anonymous 

Hi

Create DAX mesures for these all columns. Then you can change data time of measure without changing data type of Data section. ex.

Costs =  Sum(Table Name[Column Name])

Thank you.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thank you very much, Sir.

     

    So basically my only solution is to create a measure for every single column, in order to change the format to decimal number, without affecting the "data section" that is actually in currency format, is that correct?

     

     

     

     

     

     

    I 

    • Dinesh_Suranga's avatar
      Dinesh_Suranga
      Continued Contributor
      3 years ago

      Anonymous 

      Hi,

      If you want to keep your Data section coulums as currency and if you need to change columns in report as decimal then best option is creating mesures.

      Thank you.