Forum Discussion

RaffiKouzoudj's avatar
RaffiKouzoudj
Icon for Helper III rankHelper III
5 years ago
Solved

Hide columns or table using Slicer / buootn

Hello! I have around 10 tables and each table having different column headers/columns. The dashboard has slicers and based on the slicer value I want to display 1 of the tables and hide the other 9....
Need Help
Tips and Tricks
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    Hi, RaffiKouzoudj 

    According to your description, I guess that the “Filter” type of interaction between Power BI visuals may help you to achieve your requirement of using one table to dynamically hide/unhide your static column on the table or matrix.

     

    You can follow this document:

    https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

     

    Best Regards,

    Community Support Team _Robert Qin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

RaffiKouzoudj's avatar
RaffiKouzoudj
Icon for Helper III rankHelper III
5 years ago

Thank you Amit for your quick reply, the calculation groups might work however my table headers are not calculated fields. they are static columns from the table. Not sure if we have another way of doing it. I have used bookmarks with buttons however our end users were confused. Since they are using the slicer and then they need also to click the specific button! too many clicks 🙂