Forum Discussion
Anonymous
4 years agoNot applicable
Change the matrix row dynamically
Hi guys
I have more than 5 tables and i want to make only 1 matrix visualisation for the sales instead of making 5 matrix
matrix1(customer_id--------Sales)
matrix2(Region------Sales)
,matrix3(Item_category-----sales).....
I just want to make a matrix that show me the sales.
So i want to make 1 slicer that contain (Region/Customer/Item) and whenever i click on customer the matrix rows change as customer_ID and i can see all my customers and their sales,whenever i press on Region The matrix rows change to Region name and i can see all my region and their sales....
matrix1(customer_id--------Sales)
matrix2(Region------Sales)
,matrix3(Item_category-----sales).....
I just want to make a matrix that show me the sales.
So i want to make 1 slicer that contain (Region/Customer/Item) and whenever i click on customer the matrix rows change as customer_ID and i can see all my customers and their sales,whenever i press on Region The matrix rows change to Region name and i can see all my region and their sales....
here are two screens to show you what i want to acheive
Anonymous It's not generally considered a best practice but there are ways of doing this. https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-EVERYTHING-measures-axis-legend-titles-chart-types/m-p/1027881#M444
1 Reply
- Greg_DecklerCommunity Champion
Anonymous It's not generally considered a best practice but there are ways of doing this. https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-EVERYTHING-measures-axis-legend-titles-chart-types/m-p/1027881#M444