Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
dplandry
Regular Visitor

OMIT ROWS WITH NO DATA

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

2 REPLIES 2
Anonymous
Not applicable

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?

2018-05-14_10-32-54.png

 

 

 

v-yuezhe-msft
Employee
Employee

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.