Forum Discussion

daniberes's avatar
daniberes
Frequent Visitor
2 years ago

In Matrix Combine a column 'Budget' at top level then second level column Actual

I need to have one column in the matrix that will show the budget total above the group of values

Right now it is in its own column. See below, first column is budget, I want move that TOTAL into same column as Actual as a header then subtract and difference below level 

I am just stuck, I feel like it should not be that hard but I cant wrap my head around it.

 

Any suggestions would be apprectiated.

 

 

3 Replies

    • daniberes's avatar
      daniberes
      Frequent Visitor

      Let me trim down my report

      Or create a copy with fake numbers

       

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi daniberes 

     

    Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster?

    Thank you very much for your kind cooperation.

     

    If not, you can refer the following links to share the required info:

    How to provide sample data in the Power BI Forum

    How to Get Your Question Answered Quickly

    And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

    How to upload PBI in Community

     

     

    Best Regards

    Zhengdong Xu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.