Forum Discussion

AnandTrivedi's avatar
AnandTrivedi
Regular Visitor
9 years ago

Creating a time driven bullet chart

All,   I am new to Power BI and I am trying to develop a time driven bullet chart. The gist is to use the bullet chart to show the application availability times i.e. when did the batch start to ma...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi AnandTrivedi,

I can not create a time driven bullet chart without your resource table. Based on the fields you discribed, it looks like you can create a right one. Have you set the colors for different field like highlighted in bule circle in the following screenshot? Please check and try it.



If this still does not resolve your issue, please share your sample table for further analysis.

Best Regards,
Angelia

AnandTrivedi's avatar
AnandTrivedi
Regular Visitor
9 years ago

Hi v-huizhn-msft,
 

Thanks for taking a look at it.

 

I am attaching the excel (table) here. The idea is to create a bullet chart from worksheet named as  "applicationCurrentEstimate". The bullet chart needs to be based on the time completion of the batch.

 

The "batchStartTime" denotes the time at which the overnight batch starts. If the batch is running smooth and the ETA for completion is below the SLA (the target value) then the chart should be green, if it is over the SLA then it should be red. If it needs improvement then it should be amber. 

 

 

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    Hi AnandTrivedi,

    As for as I tested, it also return the blank result when we add your data. I am not sure if the time type data is not available to this custom visual, you can post the comments on below the webside.

    Best Regards,
    Angelia