Forum Discussion

n25philly's avatar
n25philly
New Member
2 years ago

Need help filtering data

Just started with BI and it seems like you need to be a programmer to actually use this which is annoying.  I need help filtering data on a chart I am creating.  I'm using a stacked column chart.

 

I work at a steel distributor and I am trying to put together a chart that shows for each day which customer orders what material and how much we booked.  I have it mostly done.  The problem I am running into is that no matter how I filter the chart shows every single customer we have for every day.  I want to make it so it only shows the customers that have activity for the specified day.  If there a way I can tell it to only show the customer if the total value does not equal 0?

Need Help

3 Replies

  • Daniel29195's avatar
    Daniel29195
    Community Champion
    2 years ago

    Hello n25philly

     

    write a measure as follow : 

    if( sum( table_name[col_name]) = 0 , blank()  ,  sum( table_name[col_name]) ) 

     

    drag this measure to the visual you are using.

     

    let me know if this works for you. 

    if not, please share a visual representation of your problem . this would be helpful to understand your specific issue. 

     

     

     

    If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. I would appreciate hitting that kudos button 👍🤠

  • n25philly's avatar
    n25philly
    New Member
    2 years ago

    I'm sorry, very new to this, what do you mean by measure and where would I write it?

    • Daniel29195's avatar
      Daniel29195
      Community Champion
      2 years ago

      n25philly 

      Measure 4 = sum(Calendario[Día])



      Calendario :  this is the table name

       

      Día :  this is the column name .

      sum(Calendario[Día]) will return the sum of values in the column of that table .
       
       
      now back to your requirement , 
      measure =
      if( sum( table_name[col_name]) = 0 , blank()  ,  sum( table_name[col_name]) ) 
       
      table_name -> change it to the table name you have. 
      col_name  -->  change ie to the column name you want to add its vaulues. 
       
      If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
      It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠