Forum Discussion

Jvo's avatar
Jvo
Frequent Visitor
1 year ago
Solved

Double Header and Secondary Column in Matrix Visual

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:  ...
Need Help
  • v-hashadapu's avatar
    v-hashadapu
    1 year ago

    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.

lbendlin's avatar
lbendlin
Super User
1 year ago
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's avatar
Jvo
Frequent Visitor
1 year ago

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

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

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