Filed Parameter + hierarchy question

[ericjo]

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.

[danextian · Accepted solution]

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.

[ericjo]

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?

[v-veshwara-msft]

Hi @ericjo ,
Thanks for posting in Microsoft Fabric Community and thanks for the update.
Just wanted to check if you were able to see the hierarchies by following @danextian  suggestion.

The hierarchy isn’t created automatically when using field parameters, but can be displayed through the option mentioned by @danextian . In addition to that, the hierarchy becomes visible when selecting Show selected fields, changing the drill on to Columns, and then using Expand all down one level in hierarchy.

Please let us know if this helps in replicating the behavior on your side.

If it still doesn’t work, could you share a PBIX file or a screenshot for further review?

Thanks @danextian  for the solution and suggestions.

[danextian]

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?

[ericjo]

You explained it so kindly, but for some reason, I've created the same table, but the hierarchical structure isn't displayed. It might be a bit cumbersome, but I'd appreciate it if you could explain it a little more.

※ This is the table i made. It creates a hierachical structure for the rows

※ This is the table u made.

[v-veshwara-msft]

Hi @ericjo ,
Thanks for the update.
Could you please try these steps to display the hierarchy.
Step 1: In the dropdown of Display Measure, make sure it is Show selected field

Step 2: Change the Drill on to Columns

Step 3: Then click on the icon to Expand all down one level in hierarchy.

Hope this helps. Please reach out for further assistance.

Thank you.