Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 !
Solved! Go to 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
Ok Sure. I am definitely going to work upon this work around. Thanks !
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
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. 🙂
Hi,
I'm new on this forum.
Where can i find the attachment?
Thanks
Tolga
I found it 🙂
Thanks
Hello, I am wondering where I can fin the attachment. Sorry, I just recently used this tool.
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
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
Ok Sure. I am definitely going to work upon this work around. Thanks !
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
User | Count |
---|---|
103 | |
87 | |
77 | |
70 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |