Forum Discussion
How to filter blank rows in Switch condition based on different slicer value
I have 3 measure , Sales , Quantity , Profit they have few blank rows . I have slicer with Sales, Qty,Profit . When Slicer value =Sales then sales>0 or not null rows when Slicer value=Qty then Qty>0...
Hi Amit , Thanks for quick reply . Slicer values are driven by enter data table values .
I have rows with Blanks and Zero's also .
In this case how can we write using SelectedValue option