Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Data, Sum SYmbol and Column Tools Issue

I have imported data into Power Bi Desktop and I am unable to adjust any options in the column tools. My data is an excel sheet on a sharepoint document folder. The columns in the sheet are set to currency and i want my visuals to show currency. Google is uselss and so here i am.

 

 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous .

    In which currency format you want your values in?
    Can you share a sample data or output?


    Thanks,
    Sanket

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      I can suggest one workaround.

      Suppose if your currency is in US dollar($) format, then you can create a custom column for currency type using below DAX;

      Currency= "$"

      Now create one more custom column and concatenate those 2 columns using CONCATENATE and use this column for all your visuals;

      New=CONCATENATE(Table[Currency],Table[Value])

      Thanks,
      Sanket.

      If this post helps, then mark it as "Accept as Solution" and give it a thumbs up.

  • v-zhangti's avatar
    v-zhangti
    Community Support
    4 years ago

    Hi, Anonymous 

     

    Can you provide some sample data or simple pbix files? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.