cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Double heading matrix with calculated columns

I have some calculated columns and need double headings as below. All the columnsI just want to group the column headings and they are not linked to the data. Please can someone help on how to achieve this. 

 

Capture.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Memorable Member
Memorable Member

@bml123 yes it is possible to achieve this result. first you organize your data in below order. Then using matrix visual, you can create output table as per your need.

 

negi007_0-1599068753052.png

 

negi007_1-1599068763986.png

 

 

View solution in original post

8 REPLIES 8
Super User II
Super User II

Hi @bml123 ,

 

Create 3 text boxes for the following:

  1. Month
  2. YTD
  3. MTD

Place these text boxes just above the headers of the matrix that you want to be included under these headings.

 

Thanks,

Pragati





If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




Super User IV
Super User IV

@bml123 , refer if this can help

https://www.daxpatterns.com/dynamic-segmentation/
https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905
https://community.powerbi.com/t5/Desktop/grouping-measure-results/td-p/456795

 

The easier way is to have text boxes on top of the matrix columns.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

I don't want to use text box as the width of the columns are not fixed.

Is there any other easy way?

@bml123 , check 2-3 links I shared



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Memorable Member
Memorable Member

@bml123 yes it is possible to achieve this result. first you organize your data in below order. Then using matrix visual, you can create output table as per your need.

 

negi007_0-1599068753052.png

 

negi007_1-1599068763986.png

 

 

View solution in original post

Thank you. How do I arrange the data in that order? Do I need to do unpivot?

@bml123 You would need alleast 3 columns (1. for Calculation type 2. Target 3. Actuals) I suggest you to share your data, I will then assist you accodingly. 

Thank you. I could organise the data as you mentioned. I followed the link below for any one needing help like me.

https://kohera.be/blog/power-bi/how-to-unpivot-twice/

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors