cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Microsoft Abhaykumar
Microsoft

Displaying integer data with events marked on a timeline

I have data like the following table:

2016-04-25 16_41_18-Yi_LowPowerStatePowerPlanIncluded.xlsx  [Read-Only] - Excel.jpg

I want to display the increasing data values by showing the difference on a Waterfall chart across x-axis time. I also want the graph to indicate the events at the proper times when they have occured. Is this possible in PowerBI? Please help if it can be done. I can't seem to find any chart type in PowerBI desktop that supports this.

5 REPLIES 5
Sean Community Champion
Community Champion

Re: Displaying integer data with events marked on a timeline

How about this set up? Its a bit different but... Why do you have separate rows for the Events?

Waterfall Chart.png

Microsoft Abhaykumar
Microsoft

Re: Displaying integer data with events marked on a timeline

Thanks Sean for replying. I have come up with the same solution but it does not look neat (its kinda a hack). Is there any way to overlay two types of data on a single chart with common x-axis? Also, if you notice the total is wrong since it takes dummy event data into account. Is it possible to remove the total at the end from the chart?

Sean Community Champion
Community Champion

Re: Displaying integer data with events marked on a timeline

Can you post an example of what you expect the result to look like?

 

I agree about the Total - I wish there was an On/Off switch for it.

Microsoft Abhaykumar
Microsoft

Re: Displaying integer data with events marked on a timeline

In the example chart that you have posted, in place of the red bars (denoting decreasing value), it would be great if there is a marker like a vertical line or even a dot with the label of event name.This would clearly depict there was an event at this time and distinguish this from other data points represented as bars.

Microsoft Eric_Zhang
Microsoft

Re: Displaying integer data with events marked on a timeline


@Abhaykumar wrote:

Is there any way to overlay two types of data on a single chart with common x-axis? ?


@Abhaykumar

 

There seems no straightforward way to do this, as a trick, you can create a new column and merge the time and eventype into one.
By the way, the data in Sean's demo looks more normalized. Enable/Disable the total sounds reasonable, we will report this internally and you can also vote for this idea.
Capture.PNG

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