Forum Discussion
Solved
Count by Month - Line Graph Not Showing Zero Values
Hi All I have a Projects table - example below: Project_ID Go_Live_Date 1 01/01/2024 2 12/01/2024 3 11/03/2024 4 01/04/2024 I have a line graph visulation with: X-axi...
Hi,
Try this approach.
- Create a Calendar Table with calculated column formulas for Year, Month name and Month number. Sort the Month name column by the Month number
- Create a relationship (Many to One and Single) from the Go_Live_Date column to the Date column of the Calendar Table
- to your visual, drag Year and Month name from the Calendar Table
- Write this measure
Measure = coalesce(distinctcount(AllProjects[ID]),0)
Hope this helps.
Hello MyThumbsClick ,
Yes you have to create separate measure for the count and after creating measure at the end of the measure please mention '+0' so that if the value is blank it will show '0'
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
Thanks Kishore_KVN
I created the below basic measure which does the trick and shows a zero value for where there is no count.
projects_per_month_count = DISTINCTCOUNT(AllProjects[id])+0
The problem im having is that i want to display the graph with a relative date filter - ''Is in the next 12 months". So Jan - March should be for months in 2025 and should appear after December but they are showing as if in normal calendar year. I have a feeling i cant achieve what im after with just a measure?