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 t...
  • 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

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