bar chart help

[Anonymous]

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

[v-juanli-msft]

Hi @Anonymous 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case and help the other members find it more quickly?

If not, please feel free to let me know.

Best Regards

Maggie

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case and help the other members find it more quickly?

If not, please feel free to let me know.

Best Regards

Maggie

[v-juanli-msft]

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.

[amitchandak]

You have to create a measure slicer and the Display of slicer should be list and orientation should be horizontal

Refer:

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

https://docs.microsoft.com/en-us/power-bi/power-bi-slicer-filter-responsive