Forum Discussion
Changing multiple (two) field parameters with one button/slicer
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!
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 meThanks a lot, was able to solve the issue with your advice.
Perfect Solution 🙂
2 years later and this solution works great! thank you!!
Perfectly elegant. Many thanks!
