Forum Discussion

JonBaylis's avatar
JonBaylis
Advocate III
9 years ago
Solved

Exclude and Include Data

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

  • 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 

9 Replies

  • samdthompson's avatar
    samdthompson
    Memorable Member

    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 

    • JonBaylis's avatar
      JonBaylis
      Advocate III

      Thanks for the reply/solution. :smileyhappy:

    • ngadiez's avatar
      ngadiez
      Helper II

      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"

    • Dave8442's avatar
      Dave8442
      New Member

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

      • bhrdrms's avatar
        bhrdrms
        Frequent Visitor

        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.

         

         

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