Creating visualisation that toggles between two different date fields

[Ben_Cates]

Hi everyone,

I think this is probably a fairly simple problem, but I cannot solve it despite my best efforts.  I'm trying to design a stacked column chart using a field parameter to allow users to toggle between two different dates.  The data all comes from a single table that I've simplified here for illustrative purposes.

I can get the field parameter slicer working well with the column chart, but my problem is that I can't change the perspective on the date - it's stuck showing single days, when I want it to show months.  As soon as I insert the field parameter into the visualisation x-axis, I seemingly lose the ability to do any drill-downs etc or filters.  Any thoughts on how I can get this chart working?

[Ben_Cates]

That fixed my problem!  Thank you 

[qqqqqwwwweeerrr · Accepted solution]

Hi @Ben_Cates 

I had a similar issue when I was working on a similar kind of data and this might help to solve the problem but for that you to modify the data 
this is sample data i have taken, you might be having multiple columns but i have taken 3

then you need to unpivot data in power query and your data should look like that 

once its done after that visual is easy and drill down option will be there 

you might require to change data orientation and rework migh take place as per your requirement.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: https://www.youtube.com/@letssolveproblem

Regards