Forum Discussion

xenon325i's avatar
xenon325i
Regular Visitor
8 years ago
Solved

Absolute Value of data

Hi all, first post here :smileyhappy:   I'm trying to show some sales data but because my data comes from an invoice table the values are all negative which doesn't look nice in my report. I'm usin...
  • xenon325i's avatar
    xenon325i
    8 years ago

    Sorry I sent the wrong sample :smileyembarrassed:

     

    I will use your work-around by adding a column at source.

     

    Thank you for your help.

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

xenon325i,

Do you connect to SQL Server database? What is the data type of  the Amount column in SQL table?

Regards,
Lydia

xenon325i's avatar
xenon325i
Regular Visitor
8 years ago

Yes it's a connection to SQL and the data type is decimal number. As you can see, the ABS value is correct in the Custom column but as soon as I try to apply my changes I get the message that I must be in Import Mode.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    xenon325i,

    Do you use Power BI Desktop August version(2.61.5192.601)? I am unable to reproduce your issue here, I create a Amount column in SQL table with decimal(18,2) data type.

    Regards,
    Lydia

    • xenon325i's avatar
      xenon325i
      Regular Visitor
      8 years ago

      Yes that is the version I am using. This is my first ever BI report so I'm probably doing something wrong because it seems I cannot do any kind of data transformation or add custom coulmns or anything at all unless I switch to import mode where it works perfectly.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        xenon325i,

        You can create a calculated column instead as shown in the following screenshot.



        Or you can add a new column which has positive values in the SQL table, then import the SQL table in Power BI Desktop using DirectQuery mode.

        Regards,
        Lydia