add_narrative_measure
Create a dynamic DAX text measure that names the top contributors to a current-prior change and states overall growth. Use it in a card for live narrative insight in Power BI.
Instructions
Auto-narrative: create a dynamic DAX text measure like 'Grated, Sliced drove +2.1% growth'. Names the top-N dimension members by contribution to the change (current - prior) and states the overall growth. Display it in a card (it updates live with slicers). Insight text without the native smart-narrative visual.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| topN | No | how many top contributors to name | |
| dimTable | Yes | dimension table, e.g. Dim_Product | |
| dimColumn | Yes | dimension column, e.g. Segment | |
| homeTable | Yes | home table for the new measure | |
| sessionId | Yes | ||
| measureName | Yes | the new measure's name, e.g. Sales Story | |
| priorMeasure | Yes | prior-period measure, e.g. Sales (Period) PY | |
| growthMeasure | Yes | overall growth % measure, e.g. Sales Growth % | |
| currentMeasure | Yes | current-period measure, e.g. Sales (Period) |