Forum Discussion
Maximizing Power BI Matrix Visual: Displaying Multiple Totals for Better Insights - Part 1
This new #powerbi #video aims to teach viewers how to display multiple totals in a matrix visual, a task that is not natively supported by the Power BI tool. The video will provide an in-depth guide on how to use the powerful WINDOW DAX functions to calculate rolling averages for comparison with current month data.
Additionally, the video will introduce viewers to the concept of calculation groups and demonstrate how to use them to create custom calculations that are not natively supported by Power BI. Calculation groups are a powerful feature in Power BI that enable the creation of custom calculations that can be reused across multiple visuals and reports. In this video, we will show viewers how to create a calculation group that allows for the calculation of multiple totals in a matrix visual.
The video is designed for beginners and advanced users alike, with step-by-step instructions and a practical demonstration of the techniques discussed. The techniques covered in this video are essential for anyone who wants to create more insightful Power BI reports and dashboards and take your data storytelling to the next level!
At the end of the video, viewers will have the opportunity to apply what they have learned in a practical exercise. By completing the exercise, viewers will gain a deeper understanding of the techniques and be better equipped to apply them in their own Power BI projects.
Enjoy and share, and leave your valuable and constructive feedback.