OMIT ROWS WITH NO DATA

[dplandry]

Hey guys

I built a report that shows sales by customer with customers down the left side and months across the top with sales figures.  The report pulls every customer regardless of whether they had sales in the current year.  How can I modify the report to only show customers with sales data?

Thanks

Dwayne

[Anonymous]

Please share the sample data for better understanding your issue. 

If a cusotmer doesn' have any sales in a year eg,2017, is there any record regarding this customer in that year, such as total sales = 0 or total sales is null?

Did you try to use advance filter to exclude the customers without sales info?

[Anonymous]

@dplandry,

Please share sample data of your table and post expected result here. If you want to show this year sales, you can create a calculated column using DAX below, then create a slicer using this column or drag this column to visual level filter and set its value to1.

Column= if(YEAR(Table[Date])=YEAR(today()),1,0)

Regards,
Lydia