This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
Hi, so I have a line graph that had 12 monthly values on, so was 12 datapoints wide. My Business Owner wants to see progress across the month - so requested that on (for example) the 20th of the month, the line is 2/3 of the way between each monthly marker, and obviously the projection is the other 1/3 of the line (for the rest of the current month, and then projected out to the end of the year.
So, I now have the data as daily, but the line graph is now 365 days wide, and so loses its impact by having to scroll along. Is there any way to remove the horizontal scroll and condense the line graph to just the real estate available. Hope this makes sense
pic 1 - daily data, pic 2 - monthly data, pic 3 - desired outcome - e.g. 20 days into August.
Thankyou
hi, @jmsav
Create a flag column for date column, for example: if ([Date]<= [variable date expression], "Show","Hide")
Then drag this field into visual/page/report level filter and set is "Show".
Best Regards,
Lin
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 35 | |
| 32 | |
| 26 | |
| 21 | |
| 18 |
| User | Count |
|---|---|
| 68 | |
| 37 | |
| 33 | |
| 23 | |
| 23 |