Forum Discussion
Expandable\Shrink Table Row
Use Matrix to get this effect!
But I can only get the matrix to drill down ever item, but I only want it to drill down once.
Hope that makes sense.
Once you set up Matrix you can set up bookmark to get the effect permanent and dynamic as well.
Apart from Matrix I donot see any other such option to expand or collapse data
edhans What is your suggestion!
By default, in a Matrix Stepped Layout is on. That may not be waht you want. You can turn it off in the formatting pane for the visual.
You can also drill down in all fields one level in one click all the way with the single-to-double-down-arrow button.
In the visual header section of the formatting pane for the visual, make sure Expand to Next Level is on. You can turn the others off. You will not see this in the desktop though, but on the service, the other drill down buttons will be removed.
Or, the bookmark suggestion by VijayP will also work. Additionally, if you drill down in your desktop and publish, that is what the users will see, so they will not need to drill down.
To get the effect where you shown a Gree Tick . After creating Matrix goto matrix properties and goto Row headers and Switch off the Stepped layout so that you will get your requird view
As shown in pic before and after
