Forum Discussion

RitzCracker's avatar
RitzCracker
Advocate II
8 years ago
Solved

Line and Stacked Column chart issue with Include & Exclude function.

Maybe it's me, but I'm having an issue with the include exclude function when you right click on a bar using the Line and Stacked Column chart.

Right clicking on the first bar I selected "Include" and got the result of seeing just that bar. 

 

Not sure as to how to get back to the original state I tried excluding the only visible bar. 

 

 

 Excluding the only visible bar leaves the visual blank. What do you have to do to get back to the original state?

 

 Please let me know what I'm missing here.

 

Thanks

 

Ross

 

 

 

Custom Visuals
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi RitzCracker,

     

    When you click the bar and select the Include, the filter condition will be added into the Visual level filter pane. The Exclude condition will also be added if you click Exclude. If you want to get back to the original chart, please remove Included and Excluded conditions from Visual level filter pane.

     

     

     

    Best Regards,
    QiuyunYu

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi RitzCracker,

     

    If you are satisfied with my response, would you please mark a helpful reply as an answer so we can close this thread?

     

    Best Regards,
    QiuyunYu

5 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    8 years ago

    Hi RitzCracker,

     

    When you click the bar and select the Include, the filter condition will be added into the Visual level filter pane. The Exclude condition will also be added if you click Exclude. If you want to get back to the original chart, please remove Included and Excluded conditions from Visual level filter pane.

     

     

     

    Best Regards,
    QiuyunYu

    • RitzCracker's avatar
      RitzCracker
      Advocate II
      8 years ago

      Thank you so much! I knew it had to be something I wasn't seeing.  

      • v-qiuyu-msft's avatar
        v-qiuyu-msft
        Community Support
        8 years ago

        Hi RitzCracker,

         

        If you are satisfied with my response, would you please mark a helpful reply as an answer so we can close this thread?

         

        Best Regards,
        QiuyunYu

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      The solution is acceptable in Power BI Desktop, but what should user do with embedded visual where Filter panel is not available?

      As of now I am able to fix the issue only by page refresh in browser.

       

      Kind regards,

      Maryia Arlova

       

  • skocheta's avatar
    skocheta
    Advocate I
    8 years ago

    Hello,

    I am facing a related issue wherein, in few of the stacked bar charts, I do not get an option to Include, Exclude. I get the option on other charts though.

     

    Is there a scenario where these options are not supposed to appear ?