Forum Discussion

dplandry's avatar
dplandry
Regular Visitor
8 years ago

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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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