Reply
mayurwadhwani
Helper I
Helper I
Partially syndicated - Outbound

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

1 ACCEPTED SOLUTION
TomMartens
Super User
Super User

Syndicated - Outbound

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

1 REPLY 1
TomMartens
Super User
Super User

Syndicated - Outbound

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)