Ensuring Sales Percentages Remain Unchanged Across Regions while using slicers in Power BI
Power BI is a platform that allows you to connect to various data sources, transform and model your data, and create interactive dashboards and reports. Power BI can help you gain insights from your data and communicate them effectively.
What is a Matrix chart in Power BI
A Matrix chart in Power BI is a visualization tool that is similar to a pivot table in Excel. It allows you to display data meaningfully across multiple dimensions. Unlike a regular table that supports two dimensions and displays duplicate values, a matrix supports multiple dimensions and automatically aggregates the data.
Context of the problem
This is a Matrix visual in Power BI with customer_region column in Rows and % of sales_per_order in Values. The matrix is showing the percentage of sales for each region. This is the normal case when everything seems correct.
But when we select only Central and East regions via slicer the percentages get recalculated keeping only these region into context which isn’t what was…