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 or not null ..etc
this should result a boolen value (true/false) get it applied to my chart as filter DAX measure Why do my SWITCH measure results have a long number despite selecting 2 decimals?
2 Replies
- amitchandak
Super User
Haric1177 , if you use a field parameter for the slicer, it should not show blank values when this measure has blank > 0 is different
for that use the selected measure code, and then create one measure and use that as visual level filter
This how you get that in case of field paremeters
Selected measure = maxx(filter(measure ,measure[measure Order] = SELECTEDVALUE(measure[measure Order])), measure[measure])
Switch(True() ,
[Selected measure] = "Sales" ,[Sales] >0, 1,
[Selected measure] = "Qty" ,[Qty] >0, 1,
0)
use visual level filter for this measure and it should be 1
Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f 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
