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.