Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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/8/1 | 200 | M |
| 2019/8/5 | 300 | S |
| 2019/8/10 | 100 | L |
How do I create a chart like this to comapre the % of Size (by pcs) in terms of specific month and YTD?
For example, in Aug --> S: 50%, M: 33%, L: 16%
YTD--> S: 32%, M: 16%, L: 53%
Thank you.
You 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...
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!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 41 | |
| 38 | |
| 36 | |
| 30 | |
| 28 |
| User | Count |
|---|---|
| 128 | |
| 88 | |
| 79 | |
| 67 | |
| 62 |