Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Hey @mayurwadhwani ,
unfortunately, the answer is short - no, it's not possible.
If you consider Power BI layered components (largely simplified), then the
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
Hey @mayurwadhwani ,
unfortunately, the answer is short - no, it's not possible.
If you consider Power BI layered components (largely simplified), then the
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