Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I have a column with 3 potential values: A, B, and C
I want to create a slicer that allows a user to choose whether or not to include B or C, but *always* includes A.
Is this possible? Are there any "hacks" to getting this done?
Hi @nbcholst,
It looks like you want to set "A" as a default selection of slicer. However, it is not possible to force a specific value as default selection.
You could submit this idea at this page.
Regards,
Yuliana Gu
You can set the default. Select it in the slicer and then save the report.
I can think of a cludge.
force the A value using a page filter. Then remove it from the filter using s visualization filter, leaving just the B and C.
"force the A value using a page filter. "
Can you explain what this means? I don't know how to make it mandatory that a page shows a value,
As far as I know a slicer will just stack on top of the page filter - if the visualization slicer just selects B & C, then including A in the page filter won't force it onto the visualization.
My response last night was from my head. I tried it this morning in PBI Desktop and it didn't work out as I thought it would.
However! I did manage to get it to work another way. I don't know how feasible this will be (it will depend on how many items you have in your slicer.
I created a data table:
A Slicer lookup table
And a table of just the keys to join this many-to-many together
The end model looks like this
Then created a table visualisation for the Data table and used the Slicer field from the Slicer table on a Slicer
I can email you the PBIX file is you would like it. PM me.
This is a brilliantly simple solution and I just used it to solve a similar problem. Thanks!!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
80 | |
65 | |
52 | |
49 |
User | Count |
---|---|
212 | |
89 | |
79 | |
68 | |
60 |