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.

[AdrianHeald]

Did you get a solution to this problem.  I too have a report published with the Filters pane hidden and the user has excluded all the data in a table.  There doesn't appear to be a way to remove that filter once it's set.

[jhcoburn]

Does anyone know how to re-add in an exluded data point on a visual.     As referenced albove,   in many cases the filter panel is hidden from the end user.   The end users are having to reset from the default top menu bar and that is applied to the entire app.   

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

[pawel-nowicki]

Good tip, but... only if filter panel is available 😄