Create matrix with main columns headhers and two subcolumns (budget and actuals).

[Anonymous]

Hello,

I am working on a budget reporting tool, where I have the following datasets:

1. Main dataset with Cost ID, Category ID, Budget 2020, Actuals 2020 (Budget)

2. One table where each Cost ID is matched with a cost Department (Departments)

3. One table where each Category ID is matched with a cost category (Category)

Since Cost ID and Category Id do not mean much for most people, I want to have a matrix, like the one shown below, where each row represents a category (this comes from the one to many relationship between Category and Budget tables) and each column has a main header which is the Department (this comes from the one to many relationship between Departments and Budget tables), as in the picture below, and then I would like two ramifications represented but "Budget" and "Actuals 2020" (they come from the main budget dataset)

I know that I can create multi-row-level but after looking around, I found no way of doing the column trick and I am afraid that it is not even possible. I hope this is clear enough, otherwise, I am happy to answer more questions.

Thanks a lot!

[Anonymous]

Hi @Anonymous,

As amitchandak said, design these in a matrix should get similar results as you mentioned.
If you still not so clear on these, please share some dummy data with raw table structure then we can test and build a sample on it.

How to Get Your Question Answered Quickly 

Please take a look at the below blog If matrix visual not mapping record value correctly:

What is the Direction of Relationship in Power BI? 
Regards,
Xiaoxin Sheng

[amitchandak · Accepted solution]

@Anonymous , Category as row, Department as Column and Budget 2020, Actuals 2020 as values in the matrix, should give this kind of display. I am missing some details