Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |