Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All, I want to create this bar chart. based on my Date pane selection (hour,Date.....Year) my chart column selected date and compare date should change. i am newbie please help
Solved! Go to Solution.
Hi @Anonymous
Hi @Anonymous
Hi @Anonymous
Hi @Anonymous
It is not clear that what date period causes the "compare date" or "selected date" to be selected, please clear me.
Based on my understanding, your problem includes these topics:
1. Dynamic X-axis in Power BI:
https://radacad.com/dynamic-x-axis-on-charts-power-bi
https://www.youtube.com/watch?v=lFd2hjkKz_Q
http://www.leanx.eu/tutorials/dynamic-dimensions-in-power-bi
2. Enlighten slicer
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380960?tab=Overview
3. Create date dimensions in power bi.
https://softcrylic.com/blogs/power-bi-for-beginners-how-to-create-a-date-table-in-power-bi/
https://exceleratorbi.com.au/build-reusable-calendar-table-power-query/
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You have to create a measure slicer and the Display of slicer should be list and orientation should be horizontal
Refer:
https://docs.microsoft.com/en-us/power-bi/power-bi-slicer-filter-responsive
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
97 | |
97 | |
73 | |
72 |