Forum Discussion
Changing multiple (two) field parameters with one button/slicer
- 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!
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!
Perfectly elegant. Many thanks!