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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
paulfink
Post Patron
Post Patron

Multiple date fields in a visual that have a shared axis from calendar table

Hi guys,

 

got a pick of a head scratcher.

 

I need to make a visual that shows how many sales have progressed in a month this year.

 

I have the dates in which they moved but there are different sale stages so i have 6 different columns with dates.

 

what i need is to put them in a stacked column chart with the Shared Axis as the Calendar Table 'Period' e.g. Dec-21.

 

How can i do it so that each calendar period has only the dates in which the sales entered that stage.

 

like this:

 

 

SS1SS2SS3SS4SS5SS6
07/06/2021     
 15/07/2021    
  20/08/2021   
   17/10/2021  
    30/10/2021 
     24/11/2021

 

i am unsure if there will be multiple dates in a single row - if there can only be 1 can simply merge the columns into one and go from there but if there is multiple in a row, what should i do

 

this is how the data looks - i want each of those dates to only go into the period it relates to 

 

i want it to show like this:

 

paulfink_4-1638955824326.png

 

how can i do this? is this possible?

 

1 REPLY 1
amitchandak
Super User
Super User

@paulfink , for this one it is better to unpivot the data so that you will get stage and date as columns 

 

https://radacad.com/pivot-and-unpivot-with-power-bi

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.