Any way to have bars behind other bars in a chart visual?

[martin_smith]

Supposing the following dataset (representing average response times for a web site in certain time periods)

Date	75th Percentile	90th Percentile	95th Percentile
2017-07-07 00:00	27	48	61
2017-07-07 01:00	18	36	47
2017-07-07 02:00	24	53	68
2017-07-07 03:00	20	48	78
2017-07-07 04:00	25	35	60
2017-07-07 05:00	15	37	49
2017-07-07 06:00	23	39	63
2017-07-07 07:00	15	35	57
2017-07-07 08:00	13	31	49

If displayed as a clustered column chart it appears as follows

If displayed as a stacked column chart it appears as

This is closer to the effect that I want but I want the bars stacked "behind" each other rather than on top of each other so the labels on the Y axis correlate with the percentile value.

If I pre-massage the data so that the 90th and 95th percentiles are calculated as the diff from the previous percentile as below...

Date	75th Percentile	90th Percentile	95th Percentile
2017-07-07 00:00	27	21	13
2017-07-07 01:00	18	18	11
2017-07-07 02:00	24	29	15
2017-07-07 03:00	20	28	30
2017-07-07 04:00	25	10	25
2017-07-07 05:00	15	22	12
2017-07-07 06:00	23	16	24
2017-07-07 07:00	15	20	22
2017-07-07 08:00	13	18	18

... then I get the visual effect that I want. The 95th percentile in the right hand column is aligned with 49. But now the tooltip functionality doesn't work as desired. Mousing over that segment shows a value of 18 rather than 49.

Is there any way that I can get the visual effect of the last attempt without having to fiddle the data - so the tooltips still show the correct information?

[v-chuncz-msft]

@martin_smith,

You may try to add calculated columns to specify additional data points that display as part of the tooltip.

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-custom-tooltips/