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 ...
  • 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!