Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Stacked colum charts

Hi, i am trying since days ðŸ˜… to have a stacked colum charts where the data are dates. In the specific: i want to report the trend that the expected end date projects varies. For each project i have ...
Need Help
  • Icey's avatar
    Icey
    6 years ago

    Hi Anonymous ,

     

    In Stacked column chart or Clustered column chart, Date is not available in y-axis.

    Please try to use Gantt visual, or try to use R visual.

    Gantt:

     

    R:

    library(ggplot2)
EndDate2 <- as.Date(dataset$EndDate, "%Y-%m-%d")
EndDate3<-format(EndDate2,"%m-%d")
Month2<-factor(dataset$Month, levels = month.name)
ggplot(dataset, aes(x = Month2, y = DateDiff_Months, fill=Project, label=EndDate3)) 
     + geom_bar(position="dodge", stat="identity")
     +geom_text(position = position_dodge(width= 1))
     +theme(legend.position = "none",axis.title= element_blank(),axis.text.y = element_blank())

     

    BTW, .pbix file attached.

     

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

In order to get your query answered correctly, you will have to add details like sample data, chart you are trying to replicate from excel, etc.

 

Thanks,

Pragati

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Pragati

 

here are my data:

 
 

for example project called Sabre, its expected end date changed (from reporting month Feb to reporting month May) from April 2020 to Dec 2020, i need to see 4 stacked columns for each expected end date and their lenght has to varies based on the time. here is what i got in xlsx for sabre 

 

this is exactly what i am trying to build in Power BI, but i can't cause the format of the data is date and whilst i can change the format in xlxs, in Power BI i cant, it automatically read those as dates...

 

i tried everything i could think of but no luck..🙄. any help?

 

thank you