cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

PowerBI pie chart exclude data points filter

Hello everyone, 

 

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"". 

 

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. 

 

I'd really appreciate your advice. Thanks. 

4 REPLIES 4
Highlighted
Super User IX
Super User IX

Re: PowerBI pie chart exclude data points filter

@kravhowe , Try with a measure like this

countx(filter(all(Table), not(table[X] in values(table[X]))),table[X])


Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Frequent Visitor

Re: PowerBI pie chart exclude data points filter

Thanks for your advice @amitchandak 

The DAX expression is correct, but still gives me an empty result. 

 

Greetings

Highlighted
Community Support
Community Support

Re: PowerBI pie chart exclude data points filt2

@kravhowe 
Please refer to the method:
https://www.skillslogic.com/blog/dashboards-data-warehousing/power-bi-how-to-show-rows-excluded-by-s...


Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted
Frequent Visitor

Re: PowerBI pie chart exclude data points filt2

Thanks for your reply @V-pazhen-msft 

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. 

 

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. 

 

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. 

 

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors