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

[RitzCracker]

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

[v-qiuyu-msft · Accepted solution]

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

[skocheta]

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 ?

[v-qiuyu-msft · Accepted solution]

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

[Anonymous]

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

[RitzCracker]

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

[v-qiuyu-msft · Accepted solution]

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