Forum Discussion

Caiz's avatar
Caiz
Frequent Visitor
5 years ago

Hide values in bar chart where value is 0

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

 

Here is a sample of my table:

 Sales TeamDevelopment TeamOperations TeamProduct Dev Team
Sick days taken0320

 

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.

bar charts
Help Requested
power bi

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    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's avatar
      Caiz
      Frequent Visitor
      5 years ago

      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's avatar
        amitchandak
        Icon for Super User rankSuper User
        5 years ago

        Caiz , Try like

         

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