Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Combine multiple column outcomes in 1 matrix

I would like to compile 1 matrix that can combine different column outcomes for the measures, depending on the months.


For example, I want to show for January up to March the Actual outcomes of those measures, and for April up to December the Forecast outcomes. Ideally I want to be able to adjust those periods with a slicer so that next month for example it shows Actual for January - April and Forecast for May - December.


Currently I can compile the matrix with only 1 of the column outcomes, so that it shows the measure values for an entire year in the same column outcome (Actual, Budget, Forecast)




I don't want to create 2 matrices (one for January - March Actual; and one for April - December Forecast) and line them up next to each other.


Does somebody know who to handle this? Is there maybe an option in current matrix visual settings that allows it, or does there exist a custom visual matrix that solves it?




Kind regards.



Could you please share dummy data of your original table so that we can test?


Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-yuezhe-msft thanks for reaching out. I hope below table with dummy data will help you in testing. I have kept the number of columns limited, in reality the original table has many more columns but for this purpose not relevant.


G/L Account No is used for defining the measures Gross Revenue (1), Direct Expense (2), and Operating Expense (3). The EBITDA measure is a calculation of Gross Revenue (1) - Direct Expense (2)- Operating Expense (3).


For now there are entries with Reporting Type 'Actual' (column value) up until March, and entries with Forecast for the remainder of the year. Next month the table will include also 'Actual' entries for April, thus I must be able to adjust the outcome matrix to show January - April with 'Actual' values, and May - December with 'Forecast' values. The matrix must be able to show different values (Actual and Forecast) of the same column (Reporting Type) depending on Posting Date.


Thanks for your effort!


2018-03-27 11_24_35-Clipboard.png

Hello !


I know my answer is a bit late but can you create a concatenation of your Year-Month-Reporting type and then trigger the filters ?


Like only filtering those :















But this has to be maintained every month... I do not know if there is a better solution really ...

Helpful resources

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Dev Camp Session 22 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!