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
michaelshparber
Advocate V
Advocate V

Unbalanced Headers in a Matrix

Hello friends,

I need to prepare a table in this format.

My client insists that they need this exact format and I wonder if there is any (maybe custom) visual that will allow me to implement the request without building a bunch of measures. I already have: Actual, Budget, Forecast, Delta - so all the rest should be just playing with Time hierarchy levels.

Please help

ThanksTable.JPG

 

1 ACCEPTED SOLUTION

One approach to solve issues like this is to produce one or more disconnected tables that contain the structure you need. From there you can write a measure that responds to the structure to give you what you need. I don’t have anything I can share that is identical to what you want, but here are 2 things you can look at that may help you understand the concept. 

 

https://exceleratorbi.com.au/measures-on-rows-here-is-how-i-did-it/

 

This next video shows how you can use tables to force a P&L structure. https://youtu.be/ojHZkWkEY7Q



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

2 REPLIES 2
MFelix
Super User
Super User

Hi @michaelshparber ,

 

Your information is very limited and to give you a better answer can you post some details on the model you already have and the calculations?

 

Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 (courtesy of @Greg_Deckler).

 

Regards,

MFelix

 

 


Regards

Miguel Félix


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

Proud to be a Super User!

Check out my blog: Power BI em Português



One approach to solve issues like this is to produce one or more disconnected tables that contain the structure you need. From there you can write a measure that responds to the structure to give you what you need. I don’t have anything I can share that is identical to what you want, but here are 2 things you can look at that may help you understand the concept. 

 

https://exceleratorbi.com.au/measures-on-rows-here-is-how-i-did-it/

 

This next video shows how you can use tables to force a P&L structure. https://youtu.be/ojHZkWkEY7Q



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

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.