Stop page level filter in filter pane to apply to just one visual

[WTAS80486]

In a pie chart I have to show all status(Draft , new, review, closed pending resolved ) but the page level filter excludes Closed and Resolved.

How can i do that if i want to keep page level filter except this one.

Any solution except that i can apply filters to each visual seperately.

[v-cazheng-msft · Accepted solution]

Hi @WTAS80486,

You may consider this solution.

1 Create a Calculated table with the status column in your table

Status List = SELECTCOLUMNS('Table',"status",'Table'[status])

2 Create a measure to count status in the new table, and take it to create the Pie chart

Also, attached the pbix file.

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please let me know. Thanks a lot!

Best Regards,                                                

Community Support Team _ Caiyun

[WTAS80486]

Thanks for the detailed solution, this is working.

[amitchandak]

@WTAS80486 ,Remove them using visual level filter

Try creating a measure like

calculate(Sum(Table[Value]), filter(all(Table[Status]), not Table[Status] in {"Closed","Resolved"}) , values(Table[Status]))

[WTAS80486]

Thanks for the reply!

calculate(Sum(Table[Value]), filter(all(Table[Status]), not Table[Status] in {"Closed","Resolved"}) , values(Table[Status]))

In Table[Value] what is value??

And in values(Table[Status] what is values??

My table name is incidents and column name status.

Also where do we use this measure in Vizualization so that it reflects in th graph to overide page level filter?