Data over Years by Day in Month view

[brianvpowerbi]

Hello,

My data set is very simple, it has 2 columns, one for Date and the other for Value.  The dates range from January 2011 through current day(by day).  I need to display a line chart where the legend is years, thus showing 7 lines(one for each year) and viewed by month.  However, i do not want to aggregate by month but rather show the unique daily values in the month view.  Please help.

Thanks

[Greg_Deckler]

I believe what you would want to do is to put Date in your Axis (not the hierarchy), in your Legend put Date | Year and in your Values put your Value column. I believe that will get you what you want.

[brianvpowerbi]

That does not seem to get the desired outcome.  If we use excel, below is an example of what I am looking for:

[Greg_Deckler]

OK, try putting Date hierarchy into the axis and drill down (double arrows not the double split arrows) to the Day

[brianvpowerbi]

this only shows the aggregate sum by day of month, not days of year

[Vvelarde]

@brianvpowerbi

Hi, Add the columns like in the image and finally Clik in Go to Lowest Level

[brianvpowerbi]

This is close, but i dont need to see the X-Axis incremented by day, but rather increments of 30 day periods.

[v-ljerr-msft]

Hi @brianvpowerbi,

Based on my testing, the solution provided by @Vvelarde above should work in your scenario. Have you tried it? If you still have any question feel free to post here.

In addition, if the solution works, could you accept the corresponding reply as solution to help others who may have similar issue easily find the answer and close this thread?

Regards