Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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.
User | Count |
---|---|
66 | |
60 | |
47 | |
33 | |
32 |
User | Count |
---|---|
86 | |
75 | |
56 | |
50 | |
45 |