How to include data back in that was excluded on a visual web published URL

[nwabramson]

Hello,

I have a visual in a report generated by Power BI that my users access by a web published url. If they select a bar and then right click and "Exclude" the data it is removed from the report. How do they include the same data back in after they exclude it? The only way I know is to refresh the report page which is not a good interface. I do not see the visual filter option that is available on the server and desktop.

Thanks for looking at this.

Nancy.

[Eric_Zhang]

---

@nwabramson wrote:

Hello,

I have a visual in a report generated by Power BI that my users access by a web published url. If they select a bar and then right click and "Exclude" the data it is removed from the report. How do they include the same data back in after they exclude it? The only way I know is to refresh the report page which is not a good interface. I do not see the visual filter option that is available on the server and desktop.

Thanks for looking at this.

Nancy.

---

@nwabramson

Could you be more specific? I think @Anonymous advice should work.

[nwabramson]

Thanks for the information. I have published to the web so generic filters are not available. This would not be a solution in my case. nwabramson

[Anonymous]

Hi @nwabramson, once you select Exclude, Power BI generates a new filter called "Excluded". If you expand the "Filters" pane (the black pane on the right hand side), look at the Visual level filters. There should be one called "Excluded" - you can either uncheck the filter options, or deleted the filter. Both will add the excluded bar back into the chart.