Primary header and secondary header for the column in the Power BI matrix table.

[Rai_Lomarques]

Hello fellow Power BI ninjas. Does anyone have any tips on how I can achieve the result below in Power BI?

I need to create a matrix table in Power BI and add a main header for the columns and another secondary header as illustrated below:

[v-karpurapud]

Hi @Rai_Lomarques 

We have not received a response from you regarding the query and were following up to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank You.

[v-karpurapud]

Hi @Rai_Lomarques 

Thanks for reaching out to the Microsoft fabric community forum. 

I would also take a moment to thank @Gabry and @danextian   , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

I hope the information provided help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you 

Best Regards, 
Community Support Team.

[danextian · Accepted solution]

Hi @Rai_Lomarques 

If Real/Budget are measures, there is no native way to put measures above the column hierarchy in matrix. A workaround is to use a disconnected table containing measure names and reference them in another measure.

Please see the attached pbix. 

[Gabry]

I just made a pbix using adventure works dataset. Take a look. You should figure it out

[Gabry]

Hey buddy,

You just need to use a matrix visual. Then, place the column with your Actual/Budget in the Columns section, and the column with the Date underneath. Of course, make sure the model is set up correctly first.

If you can upload your model I can check