Can't use Visual Filter when "First/Last/Max" summarization is set?

Question

I noticed that when I take a table or matrix and tell it to summarize the value of a column by using First/Last that once that is done you can no longer use visual filters on the object.Is that by design?&nbsp;I've tried it in about 5 different PBI files and every time I change to "summarized" it disabled visual filters.&nbsp;Here without doing summarization it works fine:Then I flip it to summarized and I can't make any changes to Filters on the visual&nbsp;

rajendraongole1 · Accepted Answer

Hi&nbsp;sasdfasdfsad&nbsp;-Yes, this behavior you are experiencing in Power BI is by design. When you use the First or Last summarization options in a table or matrix visualization, it effectively converts the column into an aggregate or summary value. Once this happens, visual-level filters on that column are typically disabled because summarizing the column turns it into a single aggregated value rather than a distinct list of values to filter from.
This is why you're unable to use filters as you would before applying the summarization.
If you want to still apply visual filters while using summarization like First or Last, here's a workaround:

Keep the column without summarizing it initially.
Use the filter pane to apply the visual filters you need on the column.
After applying your filters, you can go ahead and summarize the column using First or Last.

This process allows you to retain the filtering options while still summarizing your data for presentation purposes.
Hope this helps.

Forum Discussion

Related content

Parameter in summarize

Don't Summarize....still summarizes...?

GroupBY and summarize

Merge Summarize Table

Use Copilot to summarize