Forum Discussion
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 calculate measure based on value as false. If slicer s1 is not hidden then it would calculate measure based on value true.
Any help or suggestion would be highly appreciated.
Thanks,
Mayur
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
1 Reply
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