Need help on show/hide table visualization

[AS1110]

Hello,

I am trying to show/hide table visualization based on the slicer selection.

For ex I have 2 categories in slicer namely "Vehicle" & "Fruits",then

when user selects vehicle , the below table needs to be displayed.

Country	Category	Sales Value	Sales Volume
US	Vehicle	123	111
India	Vehicle	122	333

Similarly when one selects Fruits the below table needs to be displayed

Country	Category	Sales Value	Sales Volume
US	Fruit	123	111
India	Fruit	122	333

I tried having the below measure at the visual level filter to hide the table.But I am able to hide only the values the column headers are still appearing.Is there a way to completly hide the table?

Hide Visual =

IF (

    SELECTEDVALUE ( table[Category]) = "Vehicle",

    1,

    IF ( SELECTEDVALUE ( table[Category] ) = "Fruit",

     2 )

)

Please note that I am using live connection type to AAS

Thanks in Advance!!

[amitchandak]

@AS1110 , why are you not using a category slicer and display the same visual? Why you need to hide?

[AS1110]

Hi @amitchandak 

This is sample data.In the real scenario there is a huge data load happening for each of the categories.when I am trying to filter the data through slicer the the whole table is taking around 20 secs to load.

To reduce the time we created 4 different tables for each of the 4 categories and trying hide/show the table based on user selected value

Initially we were getting "Visual exceeded resource value error" then we optimised all of the dax queries and brought the time to 20 sec.Since this time is  not accepatble we thought of using this approach
since it is a live connection type we dont have that much of feasibilty to do any transformations in desktop.