Forum Discussion
column based on selection
Hello Nobie,
I do not know any way of setting the "expand all down" state as a default for the visual, however I did found a workaround
What we are gonna be doing is changing from one page to another, one page will have this visual in "state 1" and the other on "state 2". For this to work seamlesly the visuals must have the same positioning in the canvas on both pages
1. Create a new table that has only one column with the names our pages will have
2. Create a slicer with this field containing the name of the pages and add a button to apply the selection
3. Diplicate the pages and add to each in the filter panel, the field we were using to change the columns in the visual,selecting one state for one page, and the remaining for the other one
4. Now we assign the action to our "apply" button. Choose the option "Page Navigation" and under the conditional format option, choose the field we created on the first step containing the name of our pages.
5. Now, we can select the page we want to go to, and click (Ctrl + click in PowerBI desktop) on the apply button and it will take us to the page with the other visual.
Extras:
1. This is the only way I was able to find using a Slicer, you can do it using bookmarks but to use them you will have buttons on the page.2. Hide one of the pages so its not accesible by users, this way we avoid confusion with the duplicate.
I hope this works for you! Its a bulky solution but it does the job
Hello Nobie,
I do not know any way of setting the "expand all down" state as a default for the visual, however I did found a workaround
What we are gonna be doing is changing from one page to another, one page will have this visual in "state 1" and the other on "state 2". For this to work seamlesly the visuals must have the same positioning in the canvas on both pages
1. Create a new table that has only one column with the names our pages will have
2. Create a slicer with this field containing the name of the pages and add a button to apply the selection
3. Diplicate the pages and add to each in the filter panel, the field we were using to change the columns in the visual,selecting one state for one page, and the remaining for the other one
4. Now we assign the action to our "apply" button. Choose the option "Page Navigation" and under the conditional format option, choose the field we created on the first step containing the name of our pages.
5. Now, we can select the page we want to go to, and click (Ctrl + click in PowerBI desktop) on the apply button and it will take us to the page with the other visual.
Extras:
1. This is the only way I was able to find using a Slicer, you can do it using bookmarks but to use them you will have buttons on the page.
2. Hide one of the pages so its not accesible by users, this way we avoid confusion with the duplicate.
I hope this works for you! Its a bulky solution but it does the job
Hi Daniel,
I got what u are trying to say.
U r truly a genius.
I got one issue just ,please help.
The field parameter technique is not helping in case of waterfall chart as in waterfall chart can be drill down if I add a column in breakdown option.
But using the above solution I am not able to achieve . If some work around possible please let me know.