Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear Team,
I want exclude Zero values in Line chart , I have two condition filter tables , if these two table satified then i sum the values .
Here some days may be values zero will come, but i dont want to show if zero value available in both measures.
Table 1 :
Measurebydays = DATATABLE("Selection";INTEGER ;{{"1"};{"2"};{"7"};{"15"};{"31"}})
Solved! Go to Solution.
Can you just add a RETURN like:
IF(__var = 0, BLANK(),__var)
?
Just add measure below to visual level filter and set Show items when the value is greater than 0.
Measure 3 = [Measure] + [Measure 2]
Just add measure below to visual level filter and set Show items when the value is greater than 0.
Measure 3 = [Measure] + [Measure 2]
Can you just add a RETURN like:
IF(__var = 0, BLANK(),__var)
?
Dear
Thanks for your respond , but its not worked with my scenario 😞
What if you replace your 0 in your measure with BLANK()?
Going to be difficult to troubleshoot as the things that should normally work don't seem to be, can you share the file?
Dear
Can you guid me how to upload the file