Show/Hide a set of columns based on slicer/flag

[kpavan999]

Dear Experts,

before posting this question, I did go through existing topics but I couldnt find any relavent solution hence posting it here now.

I have a req to build a report with ~100 columns, can we have a slicer(y/n), when its selected as Y then show all columns, if selected N then show only a few columns(which i can define what columns to show)

In simple terms, I have columns A,B,C,D,E

My slicer would be

"Display All columns?"

Y

N

If selected N

output should be A,B,D

If selected Y

output should be A,B,C,D,E

[amitchandak]

@kpavan999 , if this just Y and N (for set 1 columns vs set 2 columns). you can use a bookmark. But if is based on 100 columns Y and N for each one then it bit difficult.

There is a solution for Direct Query for that without using a bookmark.

https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/

[kpavan999]

Thats correct, but I have got multiple such combinations so i need to create diff buttons for each of that combination. 

Is there a way where by selecting slicer, the bookmark button too changes to that respective page?

Lets say, if i select my slicer as Y the button should go to "sheet1" if its N then it should navigate to "sheet2"?

[V-lianl-msft · Accepted solution]

This is possible, please refer to:

https://radacad.com/page-navigation-buttons-in-power-bi 

https://powerbi.tips/2019/08/dynamic-visuals-using-buttons/