Forum Discussion

evvx234's avatar
evvx234
New Member
2 years ago
Solved

A graph displaying daily data

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! 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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
     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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