Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Thanks.
Kind regards.
@timclaeys,
Could you please share dummy data of your original table so that we can test?
Regards,
Lydia
@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!
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 :
201801ACT
201802ACT
201803ACT
201804BUD
201805BUD
201806BUD
201807BUD
201808BUD
201809BUD
201810BUD
201811BUD
201812BUD
But this has to be maintained every month... I do not know if there is a better solution really ...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |