Forum Discussion

Ben_Cates's avatar
Ben_Cates
Frequent Visitor
2 years ago
Solved

Creating visualisation that toggles between two different date fields

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?

 

 

  • qqqqqwwwweeerrr's avatar
    qqqqqwwwweeerrr
    2 years ago

    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

2 Replies

  • qqqqqwwwweeerrr's avatar
    qqqqqwwwweeerrr
    Solution Sage
    2 years ago

    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