Forum Discussion

tomgramling's avatar
tomgramling
Regular Visitor
6 years ago
Solved

Dynamic grouping based on slider selections

Here's what I'm trying to do and caveat, I'm super new to power bi so hopefully this is really easy and I just don't know what I'm doing.    I want to have a number of slicers with the same selecti...
Need Help
v-deddai1-msft's avatar
v-deddai1-msft
Community Support
6 years ago

Hi tomgramling ,

 

We can't add/remove columns with a slicer for table visual. As a workaround, we can combine bookmark and button for your requirement. Please follow the steps below:

 

1.Create the visuals for each potential selection.

 

2.Create a Bookmark for each potential selection, making the selection visible and the rest invisible .Overlay these visualizations to show only the current selection and hide the other selection.

 

 

3.Create a Button for each potential selection, to "call" the bookmark which makes the relevant visual appear.

 

 

You can also refer to :https://blog.crossjoin.co.uk/2018/04/20/dynamically-changing-a-chart-axis-in-power-bi-using-bookmarks-and-buttons/ for details.

 

After you publish it to power bi service,it will work.

 

 

 

Please refer to the pbix file: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/ETNJcMK9VxhPq27AbWqmmCEBxkT6l75jmrMPXRFSuYCTOQ?e=Tr35rK

 

 

Best Regards,

Dedmon Dai