One column in my data is the type of payment for car parks, e.g. free, pay and display, etc.
I want to add a checkbox that will filter the data to only the free car parks, i.e. when it's checked then only the free car parks are shown, when it's unchecked then all are shown. How might I do this?
If I use a normal slicer element then it shows all the different types. Which obviously can have the effect of filtering only the free ones, but is a bit more bloated than it perhaps should be.
I have added another column with DAX to indicate whether it's free or not:
Free = IF([Type of car park] = "Free", TRUE(), FALSE())
Thanks for the response. I maybe should have been more specific in my question. By applying the Free column to the slicer I still end up with two checkboxes, labelled true and false. What I'm after is just one single checkbox, labelled something like "Only show free car parks" for example. However if there is no way to do this then I suppose I'll have to make do with your suggestion.
In this scenario, since you need this "Free" to be a checkbox, I guess you will use this value for filtering/slicing data. However, unless you cascading filter a slicer, you can't remove values from a field populating into a slicer. So I suggest you just put [Type of car park] into a slicer for filtering data, and create a measure to show text like "Only show free car parks" in a Card.
Have you considered using Bookmarks? With bookmarks you can create a filtered view of your data by the use of a 'button' and apply the filter using action tab. That way when you click the button you can filter the data. You may also need another button that goes back to the unfiltered view.
Here's a video that show how to use the bookmarks feature.