Forum Discussion
Anonymous
3 years agoNot applicable
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 ...
- Anonymous3 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!
johnt75
3 years agoSuper User
If the timeframes are the same for each parameter you could maybe use a calculation group, with a calculation item for each timeframe, instead of a field parameter.