Exclude and Include Data

[JonBaylis]

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

[njones2]

Is there a way to turn off Exclude or Include as available options to end users?  

[samdthompson · Accepted solution]

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 

[Dave8442]

I do not see any solution for this. Has anyone found a solution for this yet?

[bhrdrms]

hi @Dave8442,

When you exclude any value in graphic, they will add into the filter pane over here. you will see them under the "Visual level Filter" tab.

[SandervdM]

But what if you have disabled the filter pane and the visual filter option ...

[markus_do]

There is a little round arrow in the top right corner on the menu bar. Just click and all filters and slicers will be cleared:

[pdelia]

Oof, yeah this is really a problem if you have the filter pane disabled for users. It's a useful way to sort of "drill down" on a month within a trended matrix table, but there's no way to undo it without doing a full page filter reset or maybe some kind of bookmarks?

[ngadiez]

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"

[JonBaylis]

Thanks for the reply/solution.