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 belo...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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.