Handling line graph with dates and results restriction

[nsadams87xx]

Hey everyone,

I have a line graph that has dates on the X axis.  The data I'm reporting on started in 2018 which I understand Power BI is trying to create a full calendar to accommodate proper handling of dates.  But my user doesn't want to see these dates that don't have any data.  However there are cases where zero actually means a zero percent score.  I have a chart graph that shows different healthcare provider's scores so if a user clicks on that provider but they have scores of zero, that should still reflect on the line graph.  The visualization filters I have in place are going to disrupt that.  Anyone have any ideas on how to appropriately handle this?  Screenshots...

Not acceptable:

Need this but also to accept zeros.  I've tried filtering out "blanks" and that doesn't work either.  I'm guessing because the DIVIDE() I'm using to make these percentage calculations has a + 0 after it but then my chart also shows blanks.  There are some cases where the DIVIDE is removing zeros as a result that should actually be zero.

When my DIVIDE measures have + 0 at the end of them

With DIVIDE measure without + 0 but the user wants to see 0%

[Anonymous]

Hello-

You could always try adding .000001 to every value. That way it doesn’t affect the actual scoring, but it will make a number (0.0) appear when entered.

Jared

[nsadams87xx]

Interesting idea, I'll give it a shot.