Expose Explicit "Inverted Mode" Property in Power BI Embed API for Angular
Category: Developer APIs / Embed APIs.
Description:
Currently, when using slicers in the Power BI Angular Component, the Embed API tracks only deselected items explicitly after users choose "Select All." This behavior causes significant confusion and complexity, especially when integrating slicer selections into downstream applications like paginated reports.
Specifically, the current implementation:
Does NOT explicitly indicate when slicer selections are inverted.
Requires developers to manually maintain and subtract deselections from a complete set of potential values, which is cumbersome, error-prone, and difficult to maintain, particularly with large datasets.
Proposed Improvement:
Introduce an explicit property (e.g., isInverted: true) within the filter response object provided by the Embed API. This would clearly indicate when a slicer is in "inverted mode" (i.e., "Select All" except certain items), significantly simplifying data handling and downstream report processing.
Benefits of this Feature:
Reduces complexity and improves reliability of the integration with downstream systems, such as paginated reports or middleware.
Eliminates manual, error-prone logic currently required for interpreting slicer states.
Enhances developer productivity by providing clear and semantic slicer state information.
Improves scalability and maintainability, particularly important when handling large datasets or complex reports.
Real-World Scenario (Driving this Request):
Working closely with a customer (N-able) who has identified this limitation as a significant roadblock, currently requiring substantial development workarounds or middleware logic. Clearer API semantics would greatly streamline their processes and reduce ongoing maintenance overhead.
Additional Context & Community Feedback:
Community discussions indicate similar frustrations (Example Discussion).
A straightforward API improvement here would benefit the broader Power BI Embed developer community.
Recent ideas
Allow Managed Private Endpoint to be disabled/enabled per notebook
Could notebooks have an option to use or not use the workspace's Managed Private Endpoint (MPE)? MPE can significantly increase notebook startup time, even for notebooks that don't need private conn...frithjof_v1 day agoCommunity ChampionNew25Views1like0CommentsMatrix: column totals as a bar chart docked to the edge
What's missing Data bars already work on the Total row and column through conditional formatting, so row totals can be read as length. Column totals cannot: they render as a horizontal bar inside a ...Sayurivalente1 day agoRegular VisitorNew80Views6likes1Comment