Forum Discussion
Apply filter grayed out in Top N filter with SharePoint list integration
Hi MojoC ,
You need to drag a data field (column or measure) from your Field List into here first to let PBI know what you want the TopN of:
In your screenshot, you're trying to apply the filter to [Created By], so try dragging [Step_count] into this area, which will then show you the 5 [Created By]s with the highest [Step_Count].
This allows you to apply the TopN filter to values that aren't in your visual. For example, you could show [Step_Count] by [Created By] in your visual, but filter only for the people that covered the 5 highest distances etc.
Pete
Hi MojoC ,
You need to drag a data field (column or measure) from your Field List into here first to let PBI know what you want the TopN of:
In your screenshot, you're trying to apply the filter to [Created By], so try dragging [Step_count] into this area, which will then show you the 5 [Created By]s with the highest [Step_Count].
This allows you to apply the TopN filter to values that aren't in your visual. For example, you could show [Step_Count] by [Created By] in your visual, but filter only for the people that covered the 5 highest distances etc.
Pete
