Forum Discussion
Filterable Table Visual Without the Need For Slicer
Hello there!
I'm going straight to my question. I have a table visual. I created a parameter to determine which columns will appear in the table. In other words, the user clicks on which columns they want to see and the column or columns they click on appear. There is no problem until here.
There are too many columns. But I also want the user to filter the values in these columns. I can add a slicer for each column separately. However, as I said, since there are many columns, it did not seem like a sustainable solution to me. I didn't find a table with a filtering option above each visible column like in the query editor. Or is there one, I didn't see it?
Or is there a method that can filter the values in the selected column with a single slicer? For example, if the user wants to filter the values in column "X", he/she should select the relevant column from somewhere and the numbers in the "universal" slicer should be updated accordingly and filtering should be done. (I think utopia)
Or does anyone have a more effective solution?
Thanks in advance.
4 Replies
- Kishore_KadhirResolver II
Hi sezerunar
I have a table with the sample data as shown in the image and added a filter to filter the column and the values in it. Is the solution you are after?
Thanks,
Kishore
- sezerunarFrequent Visitor
Yes, I can do that. That's fine. As I mentioned in my question, I have too many columns. For example, if there are 30 columns in the table, I don't want to add 30 slicers to filter the values.
I don't know if I'm making myself clear.
- AnonymousNot applicable
Hi sezerunar
Use a single slicer for a dynamic and user-friendly filtering interface for multiple columns in Power BI, especially if you have a large number of columns. Power BI doesn't natively support dynamically adjusting the value of a selected column.
You can explore Power BI's custom visuals in the marketplace. Some custom visuals might offer more advanced filtering capabilities that are closer to what you're looking for.Best Regards,
Jayleny
- jstew0809Frequent Visitor
PBI is lacking in so many ways. If something works in other products why not use it?