Forum Discussion
Solved
Visual Level Filter only works if same column added to Values
Somewhat new to Power BI. I'd like to filter by a column for a table visual. Let's say ColumnA. If I drag ColumnA to the Visual level filter bucket and choose a value my table does not filter by that...
- I’m assuming your only displaying column values from your table without any measure or aggregated values displayed. In this case PowerBI won’t filter. If you add the column your slicing onany measure or calculated aggregate to your table the filter will work.
If you want to use the hide column trick suggested earlier. You need to first have word wrap in columns turns off then just drag the column width to hide the displayed column you don’t want. (Near trick for sorting on something not displayed in your table)
The other option is to write a measure that returns one of your column values. Say you have column called Product Name. Rather than using product name write a measure called Produnt Bame Disply = FIRSTNONBLANK(table[Product Name])
I’m assuming your only displaying column values from your table without any measure or aggregated values displayed. In this case PowerBI won’t filter. If you add the column your slicing onany measure or calculated aggregate to your table the filter will work.
If you want to use the hide column trick suggested earlier. You need to first have word wrap in columns turns off then just drag the column width to hide the displayed column you don’t want. (Near trick for sorting on something not displayed in your table)
The other option is to write a measure that returns one of your column values. Say you have column called Product Name. Rather than using product name write a measure called Produnt Bame Disply = FIRSTNONBLANK(table[Product Name])
If you want to use the hide column trick suggested earlier. You need to first have word wrap in columns turns off then just drag the column width to hide the displayed column you don’t want. (Near trick for sorting on something not displayed in your table)
The other option is to write a measure that returns one of your column values. Say you have column called Product Name. Rather than using product name write a measure called Produnt Bame Disply = FIRSTNONBLANK(table[Product Name])
Appreciate the responses. Kinda odd that filters don't work w/o an aggregate but good to know going forward..
- Don’t know all the technical details but it has to do with the way the PowerBI data model works. The aggregate measures provide the context for filtering when there are relationships. Remember that the Measur is independent of any particular tables.