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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hey y'all;
I want to get a simple graph like this.
But powerbi keeps aggregating everything.
Also when I drill down in the hierarchy I get sums of what I need. Anyone know how to just get the raw data displayed without either the dates or the variable getting aggregated? I already have the number aggregation set to nothing but it doesn't really seem to help.
Thanks in advance!
Solved! Go to Solution.
Hi @evvx234 ,
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:
1.Create a line chart, using the date column as the x-axis and the value column as the y-axis
2.Adjust Date Fields
Click the drop-down arrow to the right of the date field
Select Date instead of Date Hierarchy
3.Final output
Best regards
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thanks so much! I missed that date option
Hi @evvx234 ,
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:
1.Create a line chart, using the date column as the x-axis and the value column as the y-axis
2.Adjust Date Fields
Click the drop-down arrow to the right of the date field
Select Date instead of Date Hierarchy
3.Final output
Best regards
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 38 | |
| 37 | |
| 28 | |
| 27 |
| User | Count |
|---|---|
| 124 | |
| 89 | |
| 73 | |
| 66 | |
| 65 |