Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
i am fairily new to Power BI so this is maybe a problem with a very obvious solution.
My problem is the following:
I have two Datasets loaded into my modell. One for actual sales data and one for budget sales data. The tables have no relationship and look something like this:
Actual Data:
Date | Quantity | Value |
12-2022 | 1 | 100 |
01-2023 | 4 | 400 |
02-2023 | 3 | 250 |
Budget Data:
Date | Quantity | Value |
12-2022 | 3 | 300 |
01-2023 | 2 | 120 |
02-2023 | 6 | 500 |
So far i had an excel document that visualized the data like this:
Actual | Budget | difference | difference % | |
Quantity | 8 | 11 | -3 | -27,2% |
Value | 750 | 920 | -170 | -18,5% |
avg. Value | 93,75 | 83,64 | 10,11 | 12% |
I would really like to recreate the exact visual in Power BI but so far i came up with nothing. I assume this can be done via a custom matrix table and i found https://community.fabric.microsoft.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-Power... this guide explaining how to create one. Sadly there are a few differences from my problem to the example in the guide (differences like i dont use an existing dimension for the rows) and i am not experienced enough yet to compensate for that.
I would really appreciate any help i could get.
Thank you very much!
So far I created two custom tables, one for the rows and another one for the columns using an idex in both tables.
These tables give me the columns and rows in the Matrix I need, but now the problem is to assign the right value to the right Row-Column pair.
I tried to put the Value-Actual measure into one field of the Matrix with following Dax Code:
User | Count |
---|---|
84 | |
69 | |
69 | |
65 | |
54 |
User | Count |
---|---|
93 | |
93 | |
91 | |
76 | |
69 |