Charts to display Dates and items

[fedo29]

Hi guys,

lets say i using MS Project Data. I need to create a graph having on X-Axis timephased data ( Jan-Feb-March-April-June.........) and on Y-Axis the name on the Project. The value to display is for example a date ( Finish date) for each Project. In this way i can display as dot the finish date for each project.

Is this achivable?

Thanks 

Federico

[Greg_Deckler]

I believe that the only visual that you are going to have at your disposal to do this would be a Matrix visualization unless there is a custom visual out there. Power BI generally does not like text values for a Y-Axis. You might be able to get there using R.

[Anonymous · Accepted solution]

There is a similar thread on this suggesting "... a scatter plot would best suit your requirement as you can put projects and dates along axis. Also check out custom visuals here for powerbi. There are few visuals that provide time based analysis such as Timebrush,  Pulsechart (check out this one particularly), Timeline and others" - see http://community.powerbi.com/t5/Desktop/Plotting-key-dates-of-a-project/m-p/73941#M30747

You could do it in R by dragging the 'Project Name' and 'Finish Date' fields to an R visual with code similar to below.  You'd then need to apply some formatting - see samples at https://community.powerbi.com/t5/R-Script-Showcase/bd-p/RVisuals

Simple R code:

library(ggplot2) # Plot visualization
library(scales) # date breaks on X axis

# Convert date to POSIXct.
dataset$`Finish Date`<- as.POSIXct(dataset$`Finish Date`,format="%Y-%m-%dT%H:%M:%OS")

# Avoid having to reference dataset$ each time in function calls
attach(dataset)

#Plot Project Name by Finish Date
ggplot(dataset, aes(x=`Finish Date`, y=`Project Name`)) +

#Present as points
geom_point () + 
  
#Use a month scale on the X-axis
scale_x_datetime(breaks = date_breaks("1 month"), labels=date_format("%d/%m/%Y")) + 
  
#Turn the X-axis title for better fit
theme(axis.text.x = element_text(angle = 90))

[fedo29]

Thank you very much, it works!!!