Hide values in bar chart where value is 0

[Caiz]

I am using a clustered bar chart to display the Sick Days taken by different teams.

Here is a sample of my table:

	Sales Team	Development Team	Operations Team	Product Dev Team
Sick days taken	0	3	2	0

My chart is currently showing all 4 teams, even those with the value of 0. How do I get it to only showing teams with more than 1, and not show the Sales & Product Dev Team on the chart?

I've tried look through a few forums and can't find a solution, I also can't do an advanced filter for some reason on e.g. "Sales Team" to only show values more than 0.

Thanks for your help.

[amitchandak]

@Caiz , If they column the only thing you can do is

Sales Team leaves = var _1  = calculate(sum(Table[Sales Team]))

if(_1 =0 , blank(),0) //You need to create for other three

If the team is column value then

Team leaves = var _1  = calculate(sum(Table[Team]))

if(_1 =0 , blank(),0)

[Caiz]

Hi @amitchandak , I am getting an error for the following query:

Australia Sales Team SL = var _1 = calculate(sum('Sick Days'[Australia Sales Team]))if(_1 =0, blank(),0)))

Error: The syntax for 'if' is incorrect. (DAX(var _1 = calculate(sum('Sick Days'[Australia Sales Team]))if(_1 =0, blank(),0))))).

[amitchandak]

@Caiz , Try like

Australia Sales Team SL =
var _1 = calculate(sum('Sick Days'[Australia Sales Team]))
return
if(_1 =0, blank(),0)

[Caiz]

@amitchandak Unfortunately it's still showing this new measure in the chart even though the value is 0