Forum Discussion

ericjo's avatar
ericjo
Icon for Helper III rankHelper III
11 months ago
Solved

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 i...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • danextian's avatar
    danextian
    11 months ago

    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.

     

     

     

danextian's avatar
danextian
Icon for Super User rankSuper User
11 months ago

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's avatar
    ericjo
    Icon for Helper III rankHelper III
    11 months ago

    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?

     

     

    • danextian's avatar
      danextian
      Icon for Super User rankSuper User
      11 months ago

      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's avatar
        ericjo
        Icon for Helper III rankHelper III
        11 months ago

        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's avatar
      v-veshwara-msft
      Icon for Community Support rankCommunity Support
      11 months ago

      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.