Forum Discussion
Filter by hidden column
Hi Anonymous
Each visual has the ability to be filtered by fields that aren't directly used as an axis or data point.
Simply drag a field to the appropriate box and configure the filter as required. I have highlighted in the image below the "visual" level filter, meaning it will only apply to this particular visual. If you use the Page or Report level filters, you can apply your filter more broadly.
That is what I am doing, but, the data doesn't change. Till now, all I only notice is that only columns being displayed, for some visuals, will allow filtering the data.
I really miss the ability to pass parameters directly to my SQL queries and have my reports change accordingly. I wonder why this hasn't been made available to Power BI. You would think tha being Power BI a more advanced and newer technology it could do anything that SSRS or other reporting tools/platforms do.