Forum Discussion

Hussain's avatar
Hussain
Icon for Helper I rankHelper I
3 years ago

Do not Aggregate data over week in a line chart

Hi,

I have dataset the granularity of which is everyday transactions. I also have a date column in it.

UniqueidsDate
15/24/2023
25/24/2023
35/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

 

Need Help
Tips and Tricks

2 Replies

  • Syk's avatar
    Syk
    Icon for Resident Rockstar rankResident Rockstar
    3 years ago

    In your x-axis, use the date and not the date heirarchy.

     

    • Hussain's avatar
      Hussain
      Icon for Helper I rankHelper I
      3 years ago

      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)