Forum Discussion

sezerunar's avatar
sezerunar
Frequent Visitor
2 years ago

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

  • 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

     

    • sezerunar's avatar
      sezerunar
      Frequent Visitor

      Hi Kishore_Kadhir 

       

      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.

  • Anonymous's avatar
    Anonymous
    Not 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

     

    • jstew0809's avatar
      jstew0809
      Frequent Visitor

      PBI is lacking in so many ways. If something works in other products why not use it?