Forum Discussion
How to include data back in that was excluded on a visual web published URL
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.
8 Replies
- AnonymousNot applicable
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-nowickiRegular Visitor
Good tip, but... only if filter panel is available 😄
- GR2020New Member
I found out that you can reset visuals how the original author had them. There should be a button in the top right corner.
- Eric_Zhang
Microsoft Employee
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.
Could you be more specific? I think Anonymous advice should work.
- nwabramson
Advocate III
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
- jhcoburnFrequent Visitor
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.
- AdrianHealdFrequent Visitor
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.