Forum Discussion

ajohnso2's avatar
ajohnso2
Icon for Solution Supplier rankSolution Supplier
2 years ago

DAX Dynamic Column population based on slicer selection

Hi All, Im looking for some advice and guidance with the below scenario. I would like to achieve this result without using Field Parameters if possible..? Some background: I have a hierarchy slice...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Why the Field Parameters restriction? This is exactly what they were designed for.

 

One alternative is to enable "Personalize Visuals" and teach your users how to use it.

  • ajohnso2's avatar
    ajohnso2
    Icon for Solution Supplier rankSolution Supplier
    2 years ago

    Hi Ibendlin,

    Thanks for your reply.

    The reason I dont want to use field parameters is it would make the report clunky, firstly having to select a slicer value from the hierarchy and additionally then selecting at which level the visual should then display.

     

    I am not completely against it personally however I know my user base would find some issue with it.

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      2 years ago

      I would give them a chance to test it before coming to conclusions.  They may end up liking the flexibility.