Forum Discussion
DPT
8 years agoRegular Visitor
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...
- 8 years agoI’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])
v-yulgu-msft
Microsoft Employee
8 years agoHi DPT,
I cannot reproduce this problem on my side. Does ColumnA added to visual level filter belong to the same dataset where you dragged other columns from to table visual? Or ColumnA is from a related dataset? Besides, please re-create the visual for a test.
Regards,
Yuliana Gu