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

how to show no value on chart if we don't Filter or click on anything

HI Team , 

 

I'd like to show No Value to the second chart  if i don't filter on anything , mean the second chart can be showed the value if we click or filter on anything. How to acheive this ? 

1.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: how to show no value on chart if we don't Filter or click on anything

Hi @Chanleakna123 

 

It seems there is no better way to achieve that.I would suggest you add a year slicer.Then create the measure like:

Measure = IF(ISFILTERED(Table1[Year]),SUM(Table1[values]),BLANK())

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: how to show no value on chart if we don't Filter or click on anything

Hi @Chanleakna123 

 

It seems there is no better way to achieve that.I would suggest you add a year slicer.Then create the measure like:

Measure = IF(ISFILTERED(Table1[Year]),SUM(Table1[values]),BLANK())

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: how to show no value on chart if we don't Filter or click on anything

hi , it works well . you're awesome. thx