Double Header and Secondary Column in Matrix Visual

[Jvo]

I am trying to accomplish recreating an Excel report in Power Bi. The count in the report is the car See the below Excel report and how the sample dataset looks: 

Report:

Dataset:

[v-hashadapu]

Hi @Jvo , We are closing this thread as we haven't heard from you in a while, according to our follow-up policy. If you have any more questions, please start a new thread on the Microsoft Fabric Community Forum. We will be happy to assist you! Thank you for being part of the community!

[v-hashadapu · Accepted solution]

Hi @Jvo , Thank you for reaching out to the Microsoft Community Forum.

Based on your description, I took some sample data and worked out the solution.

Please refer attached .pbix file for reference and share your thoughts.

If this helped solve the issue, please consider marking it “Accept as Solution” so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.

[v-hashadapu]

Hi @Jvo , Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.

[Jvo]

Unresolved.

[v-hashadapu]

Hi @Jvo , Can you please confirm if you have followed the suggestions provided by us and give more details regarding the issue and where you are struck which will let us understand the issue better. Thank you. 

[v-hashadapu]

Hi @Jvo , Thank you for reaching out to the Microsoft Community Forum.

The most effective solution is to use a Matrix visual with a hierarchy in the column section. Place Type above Brand in the Columns field. Then add Country and State to the Rows section and use the Count of Car Name in the Values section. This setup mirrors Excel’s layout by grouping brands under their respective car types and shows the counts per combination, dynamically adapting to new data. To include a Total column at the far right, turn on Column Subtotals in the Matrix Format pane under Subtotals -> Per Column Level. This provides a subtotal for all brands under each type. This gives you the Excel-style total without needing to write a separate measure, and ensures it updates automatically as your data changes.

If you need a layout that exactly replicates Excel for reporting or export purposes, create a Table visual with manually defined DAX measures for each Type/Brand combination. Then create a Total column, Add Country, State and all these measures as columns in a Table visual.

If this helped solve the issue, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.

[lbendlin]

I am trying to accomplish recreating an Excel report in Power Bi

Also known as "fighting the API".

Please keep in mind that Power BI is not Excel.  If you need Excel features, use Excel. Use Power BI's features for telling stories with your data and leading your report audience to actionable insights.

[Jvo]

To the C Suite everything is Excel. Don't kill the messenger.

[lbendlin]

Go back to the C Suite and tell them their Excel report is perfect. No need to do this in Power BI.

[audreygerred]

Hi! You can put two dimensions (or more) in the column section of the Matrix:

[Jvo]

Thank you and understood, but not the desired format.