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.
Hi all,
I'm creating a report that makes use of the clustered bar chart to show monthly expenses compared with actual budget but I'm currently lost and since I'm not that familiar with DAX and Power Bi it's hard to search for the right answer on the internet.
I have a table listing expenses in specific dates like this:
And a table with budget for each month like this:
Is there a way that I can get the totals of expenses per month and year in the same date format as the one in the Budget Table so that I can make a relationship and illustrate them in a clustered bar chart?
Thanks so much in advance
Solved! Go to Solution.
Hi, create a column in the first table
Hi, create a column in the first table
Hi,
Thanks for the reply, I've just tried it out and it seems to be just what I'm looking for.
Much appreciation
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 |
---|---|
108 | |
97 | |
75 | |
63 | |
62 |
User | Count |
---|---|
143 | |
104 | |
103 | |
82 | |
66 |