Forum Discussion
Exclude and Include Data
Hi all,
I have a visual in a report in the Power BI Service (same applies for Desktop) which is a bar chart showing number of logins per day.
If I want to exclude Saturday I right-click on the bar for Saturday and click the Exclude option so Saturday disappears. If I realise I didn't want to do that, how do I get Saturday to reappear in the visual? I can't see an option.
The only solution I can see is - Click onto another report/dashboard then click back on the report I was working on [so it reloads] and it appears again.
Is there any other way - or is it coming in a future monthly update?
Thanks,
Jon
Twitter > JonBaylis
Hi, when you right click excelude, PBI creates a exclusion on the visual level filter. You can delete that to get rid of the exclusion. In my opinion, its not an elegant solution and could be better, howevere it does work. I would prefer a further right click and unexclude option but I guess that will come in time.
// It this is a solution please mark as such
9 Replies
- samdthompsonMemorable Member
Hi, when you right click excelude, PBI creates a exclusion on the visual level filter. You can delete that to get rid of the exclusion. In my opinion, its not an elegant solution and could be better, howevere it does work. I would prefer a further right click and unexclude option but I guess that will come in time.
// It this is a solution please mark as such
- JonBaylisAdvocate III
Thanks for the reply/solution. :smileyhappy:
- ngadiezHelper II
Hi
When I exclude the bar, and I right click the data again, I cannot see anything under 'Exclude'.
Is there any bug?
1st step (118 data that I want to exclude)
2nd step: I cannot see anything under "Exclude"
- Dave8442New Member
I do not see any solution for this. Has anyone found a solution for this yet?
- njones2Advocate I
Is there a way to turn off Exclude or Include as available options to end users?