Drop Down Values from Columns

[epelton]

I need to allow the user to select values in a drop down list that map to true false columns in a table.

My table...

good attitude	friendly	outgoing
t	t	f
t	f	f
f	f	t

I need check boxes that only show the column header - so good attitude, friendly, outgoing. The user should be able to select one or multiple of these to filter the data.

By defualt, Power BI shows the columns label, then two check boxes for T and F

I tried created a pivoted table with a column for the Labels and a column just filled the Y, which I tried mapping to each of the columns in the original table. Of, I can't create multiple relationships in Power BI, so that didn't work.

I am ok with using multiple slicers, one for each column, but I want it to look like one slicer - so just the label with a check box next to it. But I think it would be better to get it to be one slicer with all of the labels.

Any ideas?

[amitchandak · Accepted solution]

@epelton , if you want one slicer selection at a time, then you can consider field parameter

Power BI- Create dynamic slicers using field parameters: https://youtu.be/H2ZxWaHAJZQ
https://medium.com/@amitchandak/power-bi-power-bi-create-dynamic-slicers-using-field-parameters-2025...

Another way is have an independent table with values t and f and then use it as per need

countrows(Table,Table[Good Attitude] in values(TF[Value]) )

example

Power BI Exclude selected Slicer value, Independent Table: https://youtu.be/lOEW-YUrAbE