Creating a visual to show support expiry.

[dbguy90]

Hi,

I feel like this should be fairly simple but I've been struggling to figure out a good way to visualize it.

Essentially I want an ordered timeline as my x-axis that goes into the forseeable future.

On the y-axis I want my product versions.

Then, I would like to plot boxes (kind of like this - https://developers.google.com/chart/interactive/docs/gallery/timeline) to visualize a count of my installs of that version.

What I'm trying to convey is the number of installs, or % of our total inventory, that will lose support at a given point on the timeline. i.e these 45 installs are good up until January 2020, these 12 installs are good up until October 2020...etc.

Any suggestions on how I could easily accomplish this?

For fields I have name, general support expiry date, extended support expiry date, product type, and product version.

[v-chuncz-msft · Accepted solution]

@dbguy90 

You may refer to the following posts.

• https://community.powerbi.com/t5/Desktop/Create-date-Parameter-asat-date-to-get-active-customers/m-p...
• https://community.powerbi.com/t5/Desktop/Trend-from-History-Table/m-p/200304#M88115
• https://community.powerbi.com/t5/Desktop/Accumulate-sum-minus-abandoned/m-p/206947#M91174