Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Dynamic parameter for none without choosing any paramter

I would like to know whether Power BI dymamic slicer can give an option None for not choosing any filter and only give the general result without choosing those parameter as what i am not haveing is able to select all/gender/age/tneure. I have created the dynamic parameter by using the following measure:
Parameter = {
    ("Gender", NAMEOF('Q1'[Gender]), 0),
    ("Age", NAMEOF('Q1'[Age]), 1),
    ("Tenure", NAMEOF('Q1'[Tenure]), 2),
}
Need Help
Show and Tell
Tips and Tricks

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Anonymous , Add the last line

     

    Parameter = {
    ("Gender", NAMEOF('Q1'[Gender]), 0),
    ("Age", NAMEOF('Q1'[Age]), 1),
    ("Tenure", NAMEOF('Q1'[Tenure]), 2),

        ("None", "", 3)

    }

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      However, I would like to have a rows: 4, column: 1 in the small multiples for bar chart. If i setted it like that it will be only 1/4 page instead of 1 page for none.

       

      what i expect is: 1 big chart for none, and rows: 4 and columns: 1 if i filter the paramter like age, gender, tenure