Continuous X-axis with monthly labels, daily data categorised by year (legend)

[Anonymous]

Hi,

Attaching PBIX

I'd like to display a line chart with side by side comparison of daily quantities for each year, with monthly x-axis labels. 

I have a simple table [Date, Quantity] with daily values for several years.

Table = CALENDAR(DATE(2019, 1,1), DATE(2021,12,31))

Quantity = ([Date].[Year] - 2010) * 20 + [Date].[MonthNo] + [Date].[Day]

Chart-1

Quantity - Values

Months (Date Hierarchy) - Axis

Years - Legend

In in the chart above, the values are summed up to each month, wheresea instead I'd like to see the Daily values. 

I can display daily values by switching the Axis to Date (rather than Date Hierarchy), but then I'm unable to display Years side by side, instead the whole chart is continuous (and x-axis granularity is not necessary monthly, depends on available size):

Chart-2

Quantity - Values

Date  - Axis

Years - Legend

What I would like is the daily values (Y) from Chart-2 in the format (monthly, by year) of Chart-1 (X)

Any ideas?

Regards,

Stefan

[Anonymous · Accepted solution]

Since none of the ideas reflected what I need, I've posted my own Idea Suggestion:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/40069978-allow-more-granular-x-ax...

Please support

[V-lianl-msft]

Hi @Anonymous ,

Unfortunately,we can't use the month and year as the axis, but corresponds to the daily value.

What we can do is to drill down to get the daily value.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @V-lianl-msft ,

thank you for your response. Could work in some cases, but I know for a fact that for our users this won't be accetable.

Especially since this is an exercise to see if we can migrate from Tableau (which can do this) to Power Bi. 

Is there a user voice request to have this implemented? (I'm asking because I don't even know how to phraze this 'feature request' correctly) 

Regards,

Stefan

[V-lianl-msft]

Hi @Anonymous ,

For voice request, please refer to this article to see if it can meet your needs.

https://docs.microsoft.com/en-us/power-bi/consumer/mobile/mobile-apps-ios-qna 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I'm sorry I meant Power Bi Ideas, I thought it's called "user voice requests"

https://ideas.powerbi.com/forums/265200-power-bi-ideas

Any idea what would be a good name for the feature in this thread?

Kind Regards,

Stefan

[V-lianl-msft]

Hi @Anonymous ,

Sorry, I misunderstood you before. You can vote for this idea or share your own idea.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.