Forum Discussion
Display bar chart/line chart result as per date range selection (month wise, week wise, day wise).
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 YuOk Sure. I am definitely going to work upon this work around. Thanks !
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. :)
Community SupportHi 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,
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 YuOk Sure. I am definitely going to work upon this work around. Thanks !