The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
I need my area chart to show no gaps when filtering the data with year and month filters. That is, if there is no sales data between May and August 2021, the line is currently cut off in the months that no sales are recorded. so between May and August the line disappears. I need it to always show up.
Hi,
Share the download link of the PBI file.
To report on things that are not there you need to use disconnected tables and/or crossjoins.
User | Count |
---|---|
59 | |
55 | |
53 | |
49 | |
30 |
User | Count |
---|---|
177 | |
88 | |
70 | |
48 | |
48 |