Power BI: median & motion
A recent demo argued using median over average for more realistic portfolio views and another showcase used AI‑generated HTML prompts to create animated, executive‑ready dashboards — both approaches speed clearer, less misleading visuals. These techniques help surface true central tendencies and make trend narratives easier to communicate to non‑finance leaders. ( )
DAX provides MEDIAN and MEDIANX to compute the midpoint of a numeric set, and a worked example shows AVERAGE = 5 while MEDIAN = 4.5 on the same sample values. (dax.guide) Microsoft documents that MEDIAN ignores blanks and that the MEDIAN function is not supported in DirectQuery when used in calculated columns or row‑level security rules. (learn.microsoft.com) Practical guidance from Power BI-focused outlets recommends using median instead of mean for skewed transaction data (for example, average order value or per‑store sales) because outliers shift the mean more than the median. (thebricks.com) Community threads show calculating a median of an aggregated measure often requires MEDIANX patterns or DAX workarounds rather than a simple MEDIAN over a measure, prompting repeated forum discussion. (community.fabric.microsoft.com) Creator Dhany Indraswara published short demos claiming AI‑generated HTML prompts can produce animated, executive‑ready Power BI cards “under a minute,” with the TikTok post registering engagement (≈172 likes on the referenced clip). (tiktok.com) There are prompt‑driven prototype tools that export dashboard wireframes or Power BI files—Mokkup.ai advertises one‑click wireframes and Docsbot hosts Power BI prototype prompts for LLMs—enabling rapid mockups that teams can iterate into production reports. (mokkup.ai) Power BI supports HTML/SVG rendering through certified and community custom visuals (HTML Content, HTML Viewer, Shielded HTML Viewer) and a popular open‑source HTML Content project is maintained on GitHub, but custom visuals run in a sandbox and therefore have tag/CSP limitations to consider. (html-content.com) Established tutorial channels like Guy in a Cube (≈535K subscribers, regular "Data Tuesday" content) and community posts showing animate.css‑based animated cards provide stepwise examples for implementing HTML/CSS animations inside Power BI using these visuals. (youtube.com)
