Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am trying to create a Cumulative chart in Power BI, but the line breaks instead of continuing when there is no data. I have created a measure to count the number of dates I need:
No. Of Meetings = CALCULATE ( COUNT ( account[Met Management Date] ), DATESYTD ( 'DateDimension'[Date] ), ALL ( 'DateDimension' ) )
This works:
However the Chart looks like this:
I don't necessarily need to use the YTD function as I'm more than happy to simply use a page filter to keep the date at 2017, I just need to fix this! I have read lots of articles on this too! The meeting column in linked directly to the primary key column (date) in the date table. Nothing seems to work, so what am I missing?!!!!
Can anybody help?!
Thanks!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.