Forum Discussion
cheny134
7 years agoFrequent Visitor
How to compare YTD and monthly data in same chart?
I have a dataset like this. Date Pcs Size 2019/1/1 100 S 2019/2/1 200 S 2019/3/1 300 L 2019/4/1 100 L 2019/5/1 200 L 2019/6/1 300 L 2019/7/1 100 M 2019/...
Greg_Deckler
Community Champion
7 years agoYou will likely need to use the Disconnected Table Trick for this as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563
cheny134
7 years agoFrequent Visitor
Hi Greg,
Thanks for your reply. But I don't know how to apply Disconnected Table in my case. Can you give me more guidence? Tahnk you!