Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi experts,
I need to build a line chart in Power BI to show the trend of some daily data year over year, but I don't have all the days. How to avoid the gap between the days with data? I need to use the Continuous axis type option (first chart) as if I change to categorical, my data doesn't fit in the chart size I need (second chart).
Thanks!!
Hi @pedronl it depends, what you want with blanks / zeros.
if you choose "to categorical" then it is preferred to show days with no data.
one alternative is to create Date table, create relationship and apply your measure. Hope this help
Proud to be a Super User!
Hi, Can you please eloborate with some visuals? I have the same query. Thanks!
User | Count |
---|---|
73 | |
70 | |
38 | |
23 | |
23 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |