cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
RitzCracker Frequent Visitor
Frequent Visitor

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.Monosnap 2017-08-24 09-26-46.jpg

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

 

Monosnap 2017-08-24 09-27-36.jpg

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

 

Monosnap 2017-08-24 09-28-45.jpg

 

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

Monosnap 2017-08-24 09-29-20.jpg

 

 Please let me know what I'm missing here.

 

Thanks

 

Ross

 

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

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

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.

 

w4.PNG

 

w5.PNG

 

Best Regards,
QiuyunYu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Moderator v-qiuyu-msft
Moderator

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

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 REPLIES 5
Moderator v-qiuyu-msft
Moderator

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

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.

 

w4.PNG

 

w5.PNG

 

Best Regards,
QiuyunYu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
RitzCracker Frequent Visitor
Frequent Visitor

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

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

Moderator v-qiuyu-msft
Moderator

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

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
skocheta Regular Visitor
Regular Visitor

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

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 ?

EagleMar Visitor
Visitor

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

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