Creating Dynamic KPI Card Titles and Retrieving Visual Dimensions in BI Dashboards
Background: I created a KPI Card displaying data up to the quarter level in the date hierarchy. A label correctly reflects the applied filter/expansion level (e.g., "Current Quarter") at the tooltip. However, when using this label in conditional formatting for the title, it returns "Current Period" instead of "Current Quarter," indicating it defaults to the unfiltered state.
Issue: The title does not inherit the expected "Current Quarter" value from the line chart visual's filter context, making dynamic title updates challenging.
Desired Improvement: I want the title to dynamically reflect the filter level (e.g., "Current Quarter") based on the visual's date hierarchy, similar to the tooltip behavior. This would streamline the creation of dynamic visuals.
Additional Request: I seek a function to retrieve a visual's width and height to optimize text title calculations.
Current formula for title :
Recent ideas
OneLake Catalog full-text and content search
Why is it not possible to search OneLake by item description or even content? So I was thinking about how a user can find a table if they don't know in which lakehouse it is located? Why can't you se...TePe6 hours agoHelper IVPlanned1.1KViews21likes5Comments