Forum Discussion
Filtering, when line chart values are with zero
Hello, PBI users,
I have this issue so I wanted to know if maybe someone knows a workaround to this situation. I have a Line Chart (sc added below) where I already made that IF the value is BLANK it returns zero, it seems ok since I know that if there is a BLANK value in the Line Chart it returns a gap. But I face a problem when I try to filter the data, I get the result of all data shown where the value is 0. I know it's kind of tricky, but is it possible to show 0 value in the chart, but when filtering I want it to become BLANK, and not appear in the chart.
When the value is 0 without filtering I get the right result.
When I filter only this year I get a line of other dates with 0 values, which I do not want. I need to see only this year in the chart without the highlighted space.
So is it possible to show BLANK values as 0, but also show them as blank when they are filtered by the date table?
Thank you for the response.
Hi obuolys123 ,
According to your description, I create a sample.
Original:
Create a measure to replace the blank value with 0:
Select this year in the slicer:
Because the date column is in the same table with the year column, so the dates can be filtered by the year slicer naturally.
Not sure what's the difference between your sample and mine, I attach my sample below, you can download it to see.
Look forward to your reply.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi obuolys123 ,
According to your description, I create a sample.
Original:
Create a measure to replace the blank value with 0:
Select this year in the slicer:
Because the date column is in the same table with the year column, so the dates can be filtered by the year slicer naturally.
Not sure what's the difference between your sample and mine, I attach my sample below, you can download it to see.
Look forward to your reply.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi obuolys123 ,
Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.
Best Regards,
Community Support Team _ kalyjHi v-yanjiang-msft ,
Yes it is, even though I found another solution yours works as well. Thank you!
