Forum Discussion
Helper IIIFiled Parameter + hierarchy question
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.
Helper IIIThank 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?
Super UserClick 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-msftCommunity Support
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 fieldStep 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.