Forum Discussion
Filed 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.
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.
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.