Need help filtering data

[n25philly]

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?

[n25philly]

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

[Daniel29195]

@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! 🤠

[Daniel29195]

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 👍🤠