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!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
Hi,
I have dataset the granularity of which is everyday transactions. I also have a date column in it.
| Uniqueids | Date |
| 1 | 5/24/2023 |
| 2 | 5/24/2023 |
| 3 | 5/23/2023 |
I want to create a line chart, have weeks on the x axis and count of unique ids on y axis but I don't want to aggregate it over weeks. I want to maintain the granularity as the day.
The default line chart does is this.
But I want this - (below visual is just an example of what I want. It is not related to my data)
Is there a way to do this in Power BI
In your x-axis, use the date and not the date heirarchy.
Hi Syk,
Yes. I did that. But now I want a separate line graph with weeks as x axis but still day as the granular data.
(Edited the question)
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 56 | |
| 52 | |
| 45 | |
| 16 | |
| 16 |
| User | Count |
|---|---|
| 108 | |
| 106 | |
| 39 | |
| 33 | |
| 25 |