Forum Discussion

Kvadratura's avatar
Kvadratura
New Member
2 years ago
Solved

Default value for parameter, connected with slicer when no value in slicer selected.

In my report I have a slicer 'ViewAs" like this: That field connected in the model with parameter: MyParameter = {     ("Manager", NAMEOF('fact'[manager_column]), 0),     ("Director", NAME...
  • Kvadratura's avatar
    Kvadratura
    2 years ago

    Thank you for your response! Actually, I have found a way to fix this: I applied a filter to the slicer using the Top N (Top 1) selection of fields order of my parameter. This fixed the hierarchy structure and displayed only the correct categories for each role, along with some default behavior when no value in the other slicer is selected.
    Sample file