Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to Solution.
This is possible, please refer to:
@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/
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"?
This is possible, please refer to: