Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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....
here are two screens to  show you what i want to acheive