PowerBI pie chart exclude data points filter

Question

Hello everyone,&nbsp;&nbsp;using a pie chart the user can exclude certain data point by clicking right and confirm "exclude". Clicking right adds a filter to the visual of type "exclude x = "abc"".&nbsp;&nbsp;Now I want to have a table which shows all the exlcuded entries. So far I was unable to achieve this. I tried to work with filters and use NOT IN, or work with a reference table and calculate the differences. No success.&nbsp;&nbsp;I'd really appreciate your advice. Thanks.&nbsp;

amitchandak · Answer

kravhowe , Try with a measure like this 
countx(filter(all(Table), not(table[X] in values(table[X]))),table[X])

kravhowe · Answer

Thanks for your advice&nbsp;amitchandak&nbsp;The DAX expression is correct, but still gives me an empty result.&nbsp;&nbsp;Greetings

anonymous · Answer

kravhowe&nbsp;Please refer to the method:https://www.skillslogic.com/blog/dashboards-data-warehousing/power-bi-how-to-show-rows-excluded-by-slicerPaul Zheng _ Community Support TeamIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

kravhowe · Answer

Thanks for your reply&nbsp;Anonymous&nbsp;Still I couldn't find a solution yet. I understand the logic behind the proposed article. As already mentioned, I thought of something quite similar.&nbsp;&nbsp;The thing is that EXCEPT(ALL('table'), 'table') does not seem to work here. However, I dont want to rule out any mistake on my side.&nbsp;&nbsp;It seem as if clicking "right" on a data point in the pie chart and confirm exclude is not the same as using a slicer. The problem can easily be reproduced.&nbsp;&nbsp;

Forum Discussion

PowerBI pie chart exclude data points filter

4 Replies

Related content

How to unalign points?

Drill through excluding specific record

Fabric Capacity Metrics Time point

PowerBI file Stared in Share Point

POWERBI Subscription