Display bar chart/line chart result as per date range selection (month wise, week wise, day wise).

[PrernaPedamkar]

Hello All,

I am a beginner in PowerBI, I require help for one of the requirements :

Display bar chart/line chart result as per date range selection (month wise, week wise, day wise).

If date range selection > 1 month, show chart in months.

If it's < 1 month, show chart in weeks.

If it's < 1 week, show chart in days. 

 

How can this be achieved in PowerBI desktop (November update)? Or a work around for the same will also do.

Thanks in advance !

[v-qiuyu-msft · Accepted solution]

Hi @PrernaPedamkar,

Date hierarchy doesn't contain week automatically. You need to create a calculated column to calculate the weeknum values. You can download the attached .pbix in my original post to have a look.

Best Regards,
Qiuyun Yu

[v-qiuyu-msft]

Hi @PrernaPedamkar,

Based on my research, it's not supported to change chart X-axis field dynamically based on the selected range in a slicer.

In your scenario, you can drag a Month, Week, Date fields into Axis property, when you checked different date range in a slicer visual, you are able to see values in different hierarchies manually.  For more information, see:  Visual hierarchies and drill-down behavior.

Best Regards,
Qiuyun Yu

[PrernaPedamkar]

Hi @v-qiuyu-msft,

Thanks for the reply.  I'll surely work upon the suggestion.  However, for displaying weekwise data I donot see week hierarchy for my date column (Column Updated- refer below screenshot).  Do I have to create a separate date table or is there any other workaround?

Thank you again for the help. 🙂

[Tolga28]

Hi,

I'm new on this forum.

Where can i find the attachment?

Thanks

Tolga

I found it 🙂

Thanks

[FinnPS]

Hello, I am wondering where I can fin the attachment. Sorry, I just recently used this tool.

[v-qiuyu-msft · Accepted solution]

Hi @PrernaPedamkar,

Date hierarchy doesn't contain week automatically. You need to create a calculated column to calculate the weeknum values. You can download the attached .pbix in my original post to have a look.

Best Regards,
Qiuyun Yu

[PrernaPedamkar]

Okay.  Thanks @v-qiuyu-msft for the help ! 🙂

Regards,

Prerna

[v-qiuyu-msft]

Hi @PrernaPedamkar,

Are you satisfied with our response? If that is a case, would you please mark a proper reply as an answer so that we can close the thread? If you have any question, please feel free to ask.

Best Regards,
Qiuyun Yu

[PrernaPedamkar · Accepted solution]

Ok Sure.  I am definitely going to work upon this work around.  Thanks !

[v-qiuyu-msft]

Hi @PrernaPedamkar,

Please mark a post which is the solution to the question as an answer. It will benefit other communities who has the seem issue to find the answer.

Best Regards,
Qiuyun Yu