topic Re: Hide values in bar chart where value is 0 in DAX Commands and Tips

Hide values in bar chart where value is 0

Caiz — Wed, 27 Jan 2021 02:22:54 GMT

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.

Re: Hide values in bar chart where value is 0

amitchandak — Wed, 27 Jan 2021 02:33:00 GMT

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)

Re: Hide values in bar chart where value is 0

Caiz — Wed, 27 Jan 2021 02:50:47 GMT

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))))).

Re: Hide values in bar chart where value is 0

amitchandak — Wed, 27 Jan 2021 03:02:29 GMT

Caiz , Try like

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

Re: Hide values in bar chart where value is 0

Caiz — Tue, 02 Feb 2021 01:34:54 GMT

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