Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by watching the DP-600 session on-demand now through April 28th.
Learn moreJoin the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now
I need to create a chart that show me the cumulative count of the leads in the database. That part is easy, as show in this image:
The problem is that for better visualization I got a request to ignore the years in the Date of the lead, so I made a custom MMDD date and It worked... Not that well. The graph is too wide and is useless:
As you can see the data are in a very awkward formatting and the graph needs to scroll all the time, unlike the first one. There is any way to do what I want?
How can I do a better graph to attend the specifications that my boss gave to me?
Did you try to create quarter of the year or only month/year instead of month/day ?
Sometimes I struggle like you but I always find what I want by trying different type of dates
- Quentin
>Did you try to create quarter of the year or only month/year instead of month/day ?
No, because I can only show these data in a day by day basis. The greatest problem is to make the chart to meet my boss expectations.
What does he expect ? Something like in the first pictures but with day by day values ?
If you have month you can calculated quarter. (Q1 = 3 first; Q2 4-6; Q3 7-9 ; Q4 10-12)
- Quentin
I do like to have a chart like the bottom one, but with real dates (or at least formatted right) and not THAT wide.
Sorry if this isn't possible.
Check out the April 2026 Power BI update to learn about new features.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 45 | |
| 38 | |
| 34 | |
| 21 | |
| 17 |
| User | Count |
|---|---|
| 66 | |
| 64 | |
| 31 | |
| 26 | |
| 26 |