Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Hi, youn can obtain the NETFEE uSing a Calculated Column:
NetFee = [TotalFee] - [ThirdParty] -[TravelExpenses] -[OtherExpenses]
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?
something like this?
Exactly like this! 🙂
how do I do it?
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.
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
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]))
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |