Forum Discussion

LiorG's avatar
LiorG
Frequent Visitor
9 years ago

Cost Overview

Hello all,    How do I create something like the picture attached, assuming I use SQL data base and have 4 columns: 1- Total Fee, 2- Third party, 3- Travel Expenses, 4- Other any ideas?   ...
LiorG's avatar
LiorG
Frequent Visitor
9 years ago

Exactly like this! :-) 

how do I do it?

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

LiorG

 

Ok, Look the image and you'll see that i use a Stacked Bar Chart and in values section Use NetFee, ThirdParty and the other columns.

 

You can change the data label going to format and select what do you want to display.

  • LiorG's avatar
    LiorG
    Frequent Visitor
    9 years ago

    Vvelarde

     

    ahh, I taught to use the Total fee as a limit, so I won't need the net fee.

    thats because each of the variables located in different files, and when creating calculated column I can only use the data in the same file.
    do you know how it's possible to creat maybe new file the variables I need from different files in order to calculate the net fee?

    Thanks,
    Lior

    • Vvelarde's avatar
      Vvelarde
      Community Champion
      9 years ago

      LiorG

       

      If the tables are related you can use a Measure to this calculation.

       

      NetFee = Calculate(sum('TABLEA'[TotalFee])-sum('TABLEX'[ThirdParty])-sum('TABLEZ'[TravelExpenses])-sum('TABLEW'[OtherExpenses]))

       

       

      • LiorG's avatar
        LiorG
        Frequent Visitor
        9 years ago

        Hi Vvelarde

        seems like unfortunately not all the table are related, I tried the use the line you wrote and power BI does not let me.
        I appreciate your help , thank you very much.

        Lior