Hi How to remove the 0 Value plot area in Line and Clustered column chart..

[Anonymous]

When i applied filter to Show the items with -"is not 0" the bar chart also got dissappeared.Kindly help.

Thanks

[Anonymous · Accepted solution]

Yes its working.👍

Thanks a ton

Tahreem 

[Tahreem24 · Accepted solution]

@Anonymous if you filter out 0 value from visual filter so it wont show date series against 0 value. 

I suggest you to create measure as mentioned in my prevoius reply. 

Filterout 0 from visual filterwith help of measure

Please don't forget to hit THUMBS UP and Accept this as a solution if it helps you!

[Tahreem24]

@Anonymous ,

You can create measure like below to ignore zero value. Refer also below screen shot.

Measure  = if(SUM(Test[Val1])>0,sum(Test[Val1]))

Please don't forget to hit THUMBS UP and Accept this as a solution if it helps you!

[Anonymous · Accepted solution]

Yes its working.👍

Thanks a ton

Tahreem 

[Tahreem24 · Accepted solution]

I am glad that I answered you query.@Anonymous 

I really appreciate you THUMB UP and Accept this as a solution so it may help others.

[rajulshah]

Hello @Anonymous,

Can you please provide the formula for the measure used for the dashed line plotted?

[Anonymous]

Hi rajulshah,

Thanks for your reply.I didnt use any measure.It was the sale projection for next 12 months.

[rajulshah]

Can you try filtering out '0' value from the graph in Visual Level Filters?

[Anonymous]

I tried.its not helping...but i used this Measure=if (sum(test[val1])>0,sum(test[val1]).

anyways Thanks for your help.

[Tahreem24 · Accepted solution]

@Anonymous if you filter out 0 value from visual filter so it wont show date series against 0 value. 

I suggest you to create measure as mentioned in my prevoius reply. 

Filterout 0 from visual filterwith help of measure

Please don't forget to hit THUMBS UP and Accept this as a solution if it helps you!