Forum Discussion

lemaribdb's avatar
lemaribdb
Icon for Helper II rankHelper II
2 years ago
Solved

NAMEOF slicer select with multiple dimensions

Hi guys!

Let's say I have such measure:

 

Parameter = {
    ("Customer Name 1", NAMEOF('Customer 1'[Cust Name]), 0),
    ("Customer Name 2)", NAMEOF('Customer 2'[Cust Name]), 1)
}

 

I use this in slicer and in matrix as a row. Depending on selection in matrix it will show me one, the other or both at once in a hierarchy (one under another).
That's great, but is there a way to tweak it so I have a slicer with True/False option that depending on choice, when "True" selected, it will show the Customer 1'[Cust Name]). So nothing fancy, just as above one.
BUT if False selected, it will show both in a hierarchy, 'Customer1'[Cust Name] and when drilled down, 'Customer 2'[Cust Name]? So as if both were selected in the original slicer.
I guess the same result would be if it either shown/hid 'Customer2'[Cust Name] but no clue which is easier.
Thank you!

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi lemaribdb 

     

    Unfortunately, Power BI DAX does not directly support dynamic hierarchies in the way you're describing purely through a measure because the hierarchy needs to be defined at the model or visual level, not dynamically through a measure.

     

     

    Best Regards,

    Jayleny

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi lemaribdb 

     

    Unfortunately, Power BI DAX does not directly support dynamic hierarchies in the way you're describing purely through a measure because the hierarchy needs to be defined at the model or visual level, not dynamically through a measure.

     

     

    Best Regards,

    Jayleny