Days with no data to show as nil

[chrisw888]

Hi

I have a dataset for the month of activity at each my locations, and I put this information into a bar chart to show me the usage % each day. I am looking to then add an average line for the month, but when I do this the average line is higher, because I have a number of days that had no usage at the location so it just shows as blank, rather than 0, as the average is working on days with value, not all days in month.

I tried writing a DAX to result in zero if there is no data on the day (my X axis is working on date hierarchy as is my slicer)

Is there a way I can write a calculated Y axis that will give me my usage % for each day, but will show 0 if the dataset has no activity for that day.

[mlsx4]

Hi @chrisw888 

You can try an if: IF (ISBLANK([% each day]), 0, [%each day])