cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
michaelshparber Regular Visitor
Regular Visitor

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

Accepted Solutions
Highlighted
Super User
Super User

Re: Unbalanced Headers in a Matrix

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 a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

2 REPLIES 2
Super User
Super User

Re: Unbalanced Headers in a Matrix

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

 

 



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

Proud to be a Datanaut!




Highlighted
Super User
Super User

Re: Unbalanced Headers in a Matrix

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 a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 415 members 3,465 guests
Please welcome our newest community members: