Deviation Rows in Matrix

[Pfoerster]

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?

[v-kelly-msft · Accepted solution]

Hi @Pfoerster ,

Just drag the deviation rows in "rows",when you expand rows in matrix ,you will see the sub-rows.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[EricHulshof]

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.