Forum Discussion
Drop Down Values from Columns
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?
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-202587d4dedbAnother 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
1 Reply
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-202587d4dedbAnother 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