Forum Discussion
Filed Parameter + hierarchy question
Currently, I have four KPI Groups A through D, each with three sub-measures.
I'm trying to create an object that displays the sub-KPIs of each selected Group by placing Groups A through D in a Slicer and using a table.
I tried to create a field parameter using 12 measures, but when two or more Groups are selected, duplicate KPIs appear. Please let me know if you have any solutions or alternatives.
Hi ericjo
Field parameters act like pseudo-dimensions, essentially serving as field selectors. When used with measures, they’re still just measures - the only difference is that their visibility depends on the field parameter slicer selection.
You can group measures in the field parameter table with a calculated column (or another method), but hierarchies won’t behave as expected in visuals that support hierarchies.
An alternative is to avoid using the field parameter fields directly and instead reference the field parameter table in another measure. If your measures use different formats, you’ll also need dynamic format strings to display them correctly.
6 Replies
Hi ericjo
Field parameters act like pseudo-dimensions, essentially serving as field selectors. When used with measures, they’re still just measures - the only difference is that their visibility depends on the field parameter slicer selection.
You can group measures in the field parameter table with a calculated column (or another method), but hierarchies won’t behave as expected in visuals that support hierarchies.
An alternative is to avoid using the field parameter fields directly and instead reference the field parameter table in another measure. If your measures use different formats, you’ll also need dynamic format strings to display them correctly.
Thank you for sharing the example file! It was very helpful, but I have one question.
I used the field parameter as a column hierarchy, and when I tried to replicate it in the file you provided, the hierarchy wasn't created. How did you create this?Click the field parameter's down arrow and then Show Selected Fields instead of its values. If this doesn't work, can you please post a copy of the pbix in your screenshot?
