Cost Overview

[LiorG]

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? 

Thanks, 

Lior

[Vvelarde]

@LiorG

Hi, youn can obtain the NETFEE uSing a Calculated Column:

NetFee =
[TotalFee]  - [ThirdParty] -[TravelExpenses] -[OtherExpenses] 

[LiorG]

Thanks @Vvelarde

my problem here is more how to create such shape of a graph, the net fee can stay blank if needed

as long as I can get it to look like the picture attached.

any idea how can I create i?

[Vvelarde]

something like this?

[LiorG]

Exactly like this! 🙂 

how do I do it?

[Vvelarde]

@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]

@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]

@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]

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

[Vvelarde]

@LiorG

Post  data model and sample Data to try to solve it