Previous Year, Current Year YTD & Future Months Forecast in Power BI | Dynamic Axis in Column Chart

[@arbazahmad7177]

Great 👍....thanks for sharing

[@PowerBIHelpline]

Thank you! Cheers!

[@sadiqabkr]

Great tricks. Well done. Very insightful and amazing. Thank you.

[@PowerBIHelpline]

Glad you enjoyed it!

[@elangovanv1050]

Thanks for your video. I have one requirement in my work If I select single month in slicer it should show only weekly graph, if I select more than one month it should show only selected month in graph. Is it possible? I tried i couldn't get it . If possible please help me.

[@anilkapkoti296]

Could you also make av video where we can show the field name above the bar chart. Where the bar having legends value. Currently i am looking for such Solutions but didnt get yet.

[@PowerBIHelpline]

Yeah, That is interesting. Thanks for the suggestion

[@GopherzHockey]

I'd like to build this but it's January and so I only have partial first month data. If I build your Cumulative Sales measure, I get just one month (Jan) vs. all months of the year. Do I actually have to wait for Feb in order for this to work? (I emailed for a copy of the .pbix so I can compare)

[@sunilpatil-kn4su]

Can we show all last years dynamically in this chart ? If I select 2023 I should get 2023ytd +jan to dec for 2023 and all other previous year values on the x axis? I know we can hardcode the year on the ordinal table but can we make it dynamic so i don't have to edit ordinal table?

[@PowerBIHelpline]

Yes we can do it.

[@peculiarfilm]

I dont think this will work if your data has both dates and values

[@PowerBIHelpline]

I am not sure if i understand your scenario. what do you mean by dates and values?