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:
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
59 | |
51 |
User | Count |
---|---|
165 | |
83 | |
68 | |
68 | |
59 |