
Grouping Measures in a Field Parameter
Field parameters are one of those Power BI features that feel like witchcraft the first time you use them. Switch between measures dynamically? No calculated columns? No DAX spaghetti? Sold. Then the report grows. And grows. And suddenly your elegant little slicer looks like the terms and conditions scroll on a software licence agreement. Somewhere around measure number fifteen, your users quietly give up and just pick whatever's at the top. This week, a customer hit exactly that wall. The Setup They had a field parameter doing its thing letting users switch between a bunch of measures in a single visual. Classic pattern, works great, 10/10 would recommend. It looked something like this: Measures List = { ("Orders", NAMEOF('Measure Table'[Orders]), 0), ("Quantity", NAMEOF('Measure Table'[Quantity]), 1), ("Total Due", NAMEOF('Measure Table'[Total Due]), 2) } Clean. Tidy. Then the business had thoughts. More measures got added. Then a few more. The slicer became a liability. What they ac
Continue reading on Dev.to
Opens in a new tab

