Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
jburklund
Helper III
Helper III

Setting up data for a matrix table

I have a flat data file for operating expenses that I am trying to turn into a Matrix so the users can download all of the data at once, instead of from 3 different tables (Revenue, Departmental Expenses, and Expenses). 

 

My sample data look like this (grey columns are filtering columns): 

Data.PNG

And I would like the matrix to output like this:

Output.PNG

 

I tried to create another data table that breaks out which variables (Taxes, Insurance, etc.) belong to each category (Revenue, Departmental Expenses, Expenses) and link it to my main data file but the matrix just repeated every value selected under each cateogory.

 

Thank you for your time.

1 ACCEPTED SOLUTION
v-yuta-msft
Community Support
Community Support

@jburklund,

 

The first table is raw data, not the table visual, right? You may unpivot the table and create one addtional category column which contains categories like 'Revenue', 'Departmental Expenses' and 'Expenses' then drag the category column and the attribute column into the rows field.

 

Community Support Team _ Jimmy Tao

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

View solution in original post

2 REPLIES 2
v-yuta-msft
Community Support
Community Support

@jburklund,

 

The first table is raw data, not the table visual, right? You may unpivot the table and create one addtional category column which contains categories like 'Revenue', 'Departmental Expenses' and 'Expenses' then drag the category column and the attribute column into the rows field.

 

Community Support Team _ Jimmy Tao

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

Thank you for the advice. I had to reorganize my data to add category and sub category columns with all of the individual variable values stored in their own row.

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors