Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I do not have a glue, how to transform my Excel Model into Power BI:
In the End, this kind of Matrix I want to show to the User: He has the possibility to choose the YTD month (as shown for example January - February) and he will get as a result the 3 Scenarious Budget, FUF and Actual but also the deviations in total and in % between FUF and Budget, Act and FUF, ACT and Budget.
When I am creating in Power BI the Matrix is not a big issue:
But how can I insert the Deviation rows into the Matrix? Is it possible?
Solved! Go to Solution.
Hi @Pfoerster ,
Just drag the deviation rows in "rows",when you expand rows in matrix ,you will see the sub-rows.
Hi @Pfoerster ,
Just drag the deviation rows in "rows",when you expand rows in matrix ,you will see the sub-rows.
If you put them in the Rows of your matrix you should be able to expand budget FUF and actual. If not please post your data structure (how is it saved in power bi) for better help.
Quality over Quantity
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |