Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Changing multiple (two) field parameters with one button/slicer

Hi there! Is it possible to change multiple (in my case two) field parameters using only one button/slicer in Power BI.   In my case, I am creating a sort of dynamic Sankey diagram with Weights ...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous !

    I know this is a old topic, but I had the same problem, and your topic was top indexed on google, so I'll post how I solved it here, so it may help other people.
    instead of using the code you thought of, you can use this one:

    New_Parameter = {
    ("Timeframe 1", NAMEOF('Table1'[a]), 0, "TF 1"),
    ("Timeframe 2", NAMEOF('Table1'[b]), 1, "TF 2"),
    ("Timeframe 3", NAMEOF('Table1'[c]), 2, "TF 3"),
    ("Timeframe 1", NAMEOF('_Measures'[SankeyCount_timeframe1]), 3, "TF 1"),
    ("Timeframe 2", NAMEOF('_Measures'[SankeyCount_timeframe2]), 4, "TF 2"),
    ("Timeframe 3", NAMEOF('_Measures'[SankeyCount_timeframe3]), 5, "TF 3")
}

    It will create a new column in the parameter, and you'll be able to put this new column on the segment, as will return only the group values.

    It should work!





Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous !

I know this is a old topic, but I had the same problem, and your topic was top indexed on google, so I'll post how I solved it here, so it may help other people.
instead of using the code you thought of, you can use this one:

New_Parameter = {
    ("Timeframe 1", NAMEOF('Table1'[a]), 0, "TF 1"),
    ("Timeframe 2", NAMEOF('Table1'[b]), 1, "TF 2"),
    ("Timeframe 3", NAMEOF('Table1'[c]), 2, "TF 3"),
    ("Timeframe 1", NAMEOF('_Measures'[SankeyCount_timeframe1]), 3, "TF 1"),
    ("Timeframe 2", NAMEOF('_Measures'[SankeyCount_timeframe2]), 4, "TF 2"),
    ("Timeframe 3", NAMEOF('_Measures'[SankeyCount_timeframe3]), 5, "TF 3")
}

It will create a new column in the parameter, and you'll be able to put this new column on the segment, as will return only the group values.

It should work!





Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks for your reply. I am going to try this out and mark your answer as solution if it works :D.

Thanks again in any case since the question was still relevant and open for me