Forum Discussion

AS1110's avatar
AS1110
Frequent Visitor
4 years ago

Need help on show/hide table visualization

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.

CountryCategorySales ValueSales Volume
USVehicle123111
IndiaVehicle122333

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

CountryCategorySales ValueSales Volume
USFruit123111
IndiaFruit122333

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!!

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

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

    • AS1110's avatar
      AS1110
      Frequent Visitor
      4 years ago

      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.