Power BI currently lacks the ability to dynamically show or hide visuals—including buttons—based on DAX measures. This is a critical limitation when designing interactive, personalized, or role-based reports.
Why this matters:
Many reports need to show or hide elements (e.g., buttons, shapes, visuals) based on the logged-in user, filters, or business rules.
Currently, developers must use complex and clunky workarounds involving bookmarks, duplicate pages, and layered visuals to simulate dynamic visibility.
Transparent shapes or cards used as blockers still consume mouse focus, preventing interactivity with hidden elements underneath.
Bookmark-based workarounds are hard to maintain and scale.
Proposed enhancement:
Add a “Visible” property to all visuals and buttons in the Format pane that accepts a DAX measure returning TRUE/FALSE.
When the measure evaluates to TRUE, the visual is shown; when FALSE, it's hidden.
This would work similarly to how conditional formatting currently works for properties like color, text, and values.
Example usage:
ShowButton = USERPRINCIPALNAME() IN {"manager@company.com", "admin@company.com"}
Set this as the visibility condition for a button to make it accessible only to specific users.
Benefits:
Cleaner, more maintainable reports.
Enables true role-based UI without duplicating pages or using bookmarks.
Improves usability and report security.
Aligns with how other platforms (e.g., Power Apps) handle visibility.
on:
Small multiples category axis can't be a local cal...
miguel
on:
Support dynamic sources and destinations in Datafl...
sairamyeturi
on:
control rate of lakehouse Materialized Lake View (...