Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Pfoerster
Helper III
Helper III

Deviation Rows in Matrix

Hello,

I do not have a glue, how to transform my Excel Model into Power BI:

Test.JPGIn 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:

Test2.JPG

 

 

 

But how can I insert the Deviation rows into the Matrix? Is it possible?

1 ACCEPTED SOLUTION
v-kelly-msft
Community Support
Community Support

Hi @Pfoerster ,

 

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

 

Annotation 2020-02-19 133247.png

 

Best Regards,
Kelly
 
Did I answer your question? Mark my post as a solution!

View solution in original post

2 REPLIES 2
v-kelly-msft
Community Support
Community Support

Hi @Pfoerster ,

 

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

 

Annotation 2020-02-19 133247.png

 

Best Regards,
Kelly
 
Did I answer your question? Mark my post as a solution!
EricHulshof
Solution Sage
Solution Sage

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


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


Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.