cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AnandTrivedi
Regular Visitor

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 make the application available and when was the application available for use by the user. I had downloaded  the sample and did some investigation myself but was not able to achieve what I want.

 

Steps done so far - 

 

1. Created a table with following columns :

 

AppliactionName| ETA| Target| Minimum| Satisfactory| Good| Very Good| Maximum| Needs improvement

ApplicationTable.JPGCurrentState.JPG

The values for all of the columns (apart from Application Name) is HH:MM:SS.

 

2. Dragged the values to the corresponding fields for bullet chart custom visual but unfortunately the attached is where I get. 

 

I'd greatly appreciate if someone is able to help me out and point the mistake I am making. I am attaching some screenshots as well.

3 REPLIES 3
Microsoft v-huizhn-msft
Microsoft

Re: Creating a time driven bullet chart

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.

1.PNG

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

Best Regards,
Angelia

AnandTrivedi
Regular Visitor

Re: Creating a time driven bullet chart

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. Capture.JPG

 

 

Microsoft v-huizhn-msft
Microsoft

Re: Creating a time driven bullet chart

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

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors