Forum Discussion
How to use Top N visual filter with Field parameter?
I have two field parameters: Parameter1 = { ("Year", NAMEOF('Dates'[Year]), 0), ("Month", NAMEOF('Dates'[Month]), 1), ("Week", NAMEOF('Dates'[Week]), 2) } Parameter2 = { ("Activity", NAMEO...
Interesting. What is the 'slicer table' and how is it related to the field parameter ? It is my understanding that you can't use SELECTEDVALUE directly with the table created for a field parameter.
Hey - so I have my field parameter table, and a separate 'normal' table that I'm using for the slicer. These tables have a relationship with each other. I didn't set it up as a workaround specifically for the purpose of this solution, I had it like this already because I have one slicer table controlling multiple field parameters.
However I did just test my formula by changing the SELECTEDVALUE part to a column from the field parameter table (instead of the equivalent column in my slicer table) and it does seem to work too.