Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I'm having an issue with creating a Matrix Visual that will return custom totals at the end of the table. What I have is rows Categories and Columns have Calendar dates and i want to display Totals, Averages and Variances after the calendar date, which is dynamic based on a slicer, what this means is I will have a slicer to select a month and the Matrix visual will return the last 6 months including the current selected month and also do those calculations like Total, Average , Month on Month Variance and a % Change
Below example i selected the month of June 2023 from my slicer
Solved! Go to Solution.
Thank you however i got my answer from this youtube video. Very informative,
Maximizing Power BI Matrix Visual: Displaying Multiple Totals for Better Insights
You can have custom totals, but only as many as you have column fields. In your case you have one field (date) so you get one total.
Thank you however i got my answer from this youtube video. Very informative,
Maximizing Power BI Matrix Visual: Displaying Multiple Totals for Better Insights
User | Count |
---|---|
94 | |
86 | |
78 | |
69 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |