Forum Discussion
Shannon-COTR
3 years agoRegular Visitor
Remove Gaps When Comparing Year over Year
I'm trying to create a line graph that compares our weekly (Sunday) attendance year-over-year. My raw data contains unique dates for each Sunday from 2019-2023 as well as a caculated week number. Pow...
parry2k
3 years agoSuper User
Shannon-COTR whatever measure you are using on values just add zero to it.
Measure = COUNTROWS ( Table ) + 0
👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️
Shannon-COTR
3 years agoRegular Visitor
Thanks, but I'm not using any calculated measures at all so I don't think that this would work.