I am pulling bugs data from Azure DevOps and creating a Bar Chart to show how many Bugs are created each day. PFB snip
But here I am not able to show the dates (Days) when there are no bugs. They are just excluded from the visual.
I tried "Show Items with no data" option ; I tried using DAX measure for values as: IF(ISBLANK(Count(Bugs)), 0 , Count(Bugs)) as well but no luck.
All the data is there in the single table itself. I am using Calculated Column Day in Y-Axis of this visual for showing days.
Day = 'Bugs DevOps'[Created Date].[Day] & " " & LEFT('Bugs DevOps'[Created Date].[Month],3)
[Created Date] is the default date column in the table.
When there is no bug created for a particular workstream on a particular date then that date (Day) is not showing up in the visual. (3 Feb, 6 Feb, 7 Feb are not showing up on the Y-axis below as there are no Bugs created for that particular workstream on those days)
I want all the days to be displayed on the Y-axis and show a 0 (Blank will also do, but Y-axis should have all Days displayed) against it when there are no bugs for a given workstream on that Day. Please help me on this
P.S. The below result is same even if I just drag the [Work Items] into Values field. This below measure isn't creating any difference.