Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Ben_Cates
Frequent Visitor

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.

Ben_Cates_0-1704420628836.png

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_1-1704420725398.png

 

1 ACCEPTED SOLUTION
qqqqqwwwweeerrr
Super User
Super User

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

qqqqqwwwweeerrr_0-1704551320764.png

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

qqqqqwwwweeerrr_1-1704551386330.png

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

qqqqqwwwweeerrr_2-1704551451409.png

 

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

View solution in original post

2 REPLIES 2
Ben_Cates
Frequent Visitor

That fixed my problem!  Thank you 

qqqqqwwwweeerrr
Super User
Super User

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

qqqqqwwwweeerrr_0-1704551320764.png

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

qqqqqwwwweeerrr_1-1704551386330.png

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

qqqqqwwwweeerrr_2-1704551451409.png

 

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors