Drilling Line Chart Time Series

[lizzy]

I have a line chart with dates on the x axis and count of a specific event on the y axis. I have a slicer to define the date range I am interested in.

In a time series chart that has a date hierarchy, I can drill into a specific point to adjust the granularity. Is it possible to show the full time range that I am considering at whatever granularity selected?

For instance, if I am selecting a time range of 2018 and 2019, and a monthly granularity, I would want Jan 2018, Feb 2018, Mar 2018, ...,Jan 2019, Feb 2019, Mar 2019, ... Dec 2019. I do not want Jan 2018 added with Jan 2019, nor only show the months in 2019.

Thoughts?

[amitchandak · Accepted solution]

If you have taken date and it is using hierarchy, You can use "Expand all down .." (Inverse-square Y) till the month level. Also, you can remove the day from the fields. It should sort correctly.

In case you are using custom column like MMM-YYYY, create a new column YYYYMM and mark that as the order by column of the first column.

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601