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, thanks for looking. I have read through a few other post, yet I am still puzzled. Since my matrix is filtered to two dimensions, it is a little to complex for my skill level.
Here is the smaple pbix link:
Ultimately, I'd like to look like this smaple:
Thanks again for looking.
Terry
Solved! Go to Solution.
Create Measures for each variation of Dollars like this:
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
You may download my PBI file from here.
Hope this helps.
Thank you as well Ashish for taking the time to help me. As I mentioned to Shawne, this makes perfect sense now that i see it.
Terry
You are welcome.
@tbobolz , You need have all you four-measure Actual, Budget, Variance and Variance % and Show them in matrix with option - "Show on Row"
Create Measures for each variation of Dollars like this:
Thank you Shawne,
This looked so painful obvious once i seen it. 🙄 I apprecaite you taking the time to assist!
No problem at all! Glad to help. In this table structure it is easier to calculate than when Budget and Actuals are in seperate tables. But if you ever encounter that, here is a great reference. Again, way more tricky when delaing with multiple finance tables, but this article is very helpful if you run into it as you get deeper and deeper into DAX. https://www.daxpatterns.com/budget/
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |