Dynamically change row in matrix on droplist slicer

[Majidbhatti]

Hi

I have 5 dimensions, each i want to plot it in Matrix with fixed columns as below. Now instead of creating 5 pages each having 1 Matrix; i want to have one matrix which should be filled based on some slicer. So the user select option in the slicer and it should populate the matrix based on the selection. How can i do that? 

1)  Sources     -      Actuals          Budget         Forecast

      --------    -    ----------------------------------------

2)  Companies     -      Actuals          Budget         Forecast

     -------------    -    ----------------------------------------

3)  Nationalities     -      Actuals          Budget         Forecast

     --------------    -    ---------------------------------------

[Anonymous]

Hi,

Did you get the solution for this? I am facing the same issue where in we have been asked to create several different cuts basis static attributes for eg by Branch, By City, By Ticket size bucket, by ROI bucket etc. Its consumes lot of pages and effort. It would be great if we can dyamically change the dimensions using a slicer in the same page with one matrix table.

Let me know if you cracked it already. would be of big help.

Thanks

[parry2k · Accepted solution]

@Majidbhatti it is good candidate of bookmark and selection , here is video to show this functionality which I believe get you the solution

[Anonymous]

Hello can we do it without bookmark, just like selecting from the dropdown , we can control the row getting displayed in a matrix?

[Majidbhatti]

@parry2k  thanks for the suggestions, i dont see any value with bookmarks.

From Developer view, I still need to create all pages and than hide it behind bookmarks. From user view, either click on bookmark or page tab, its just one click.

[parry2k]

@Majidbhatti understood, even if you user slicer, use has to click somewhere to change the view, bookmark is more elegant to use instead of pages. Also you don't need to creates 3 pages, you can visual on one page and hide visual based on the selection.