Forum Discussion

nwabramson's avatar
nwabramson
Icon for Advocate III rankAdvocate III
9 years ago

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

  • Anonymous's avatar
    Anonymous
    Not 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-nowicki's avatar
      pawel-nowicki
      Regular Visitor

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

      • GR2020's avatar
        GR2020
        New 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's avatar
    Eric_Zhang
    Icon for Microsoft Employee rankMicrosoft 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.


    nwabramson

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

    • nwabramson's avatar
      nwabramson
      Icon for Advocate III rankAdvocate 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

  • jhcoburn's avatar
    jhcoburn
    Frequent 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.   

  • AdrianHeald's avatar
    AdrianHeald
    Frequent 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.