cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
lizzy Frequent Visitor
Frequent Visitor

Drilling Line Chart Time Series

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?

1 ACCEPTED SOLUTION

Accepted Solutions
amitchandak Super Contributor
Super Contributor

Re: Drilling Line Chart Time Series

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

View solution in original post

1 REPLY 1
amitchandak Super Contributor
Super Contributor

Re: Drilling Line Chart Time Series

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

View solution in original post

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)