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?
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.
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.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!