Forum Discussion

mayurwadhwani's avatar
5 years ago
Solved

Capture Using DAX whether visual is hidden or not

Hello Experts,   Is there any way where we can find whether visual is hidden or not(True/False) and capture result in DAX code. For example, If slicer say s1 is hidden then in DAX code would calcu...
  • TomMartens's avatar
    5 years ago

    Hey mayurwadhwani ,

     

    unfortunately, the answer is short - no, it's not possible.

     

    If you consider Power BI layered components (largely simplified), then the

    • bottom layer can be considered Power Query (connecting to data sources and shaping the data using the power of M)
    • medium layer (the data model, with all the DAX magic)
    • tip of the iceberg layer, data visualization, and the interaction model (filtering the data)

    The top layer (data visualization) creates DAX statements to query the underlying data model, but in a certain way the communication is one way, for this reason, it's not possible to create a DAX statement (a measure) that checks if a visual is visible or not.

     

    Hopefully, this provides more insights.

     

    Regards,

    Tom