Mark periods in a combination chart or create an additional axis

[ispajic]

Hi, is there any way to create a chart as the one below, where I would have a chart for user engagement, and I could define what the key periods are within the chart using a separate table, like on image 1:

or alternatively, create a second axis for these periods like in image 2:

Or anything that might resolve this issue?

[v-frfei-msft]

Hi @ispajic,

Could you please share sample data of your table and the logic you uses to mark the periods ? Based on my test, it is impossible to create the chart as your second image currently. Here we can only add hierarchy in the Aixs, then we can drill up / down like this. Here I group the type Column and create a calculate column using the formula as below.

Per = IF(Table1[Index]>1 && Table1[Index]<4,"P1",IF(Table1[Index]>6 && Table1[Index]<10 ,"P2", IF(Table1[Index]>11 && Table1[Index]<14,"P3")))

For more details, please check the pbix as attached. By the way, there is an idea about that, you can vote it up.

https://www.dropbox.com/s/aux0mikx96ilbh8/Mark%20periods%20in%20a%20combination2.pbix?dl=0

Regards,

Frank

[ispajic]

Hi, thank you! Unfortunately, drilldown won't work.

As to tables I'm using, what I've shown is a mockup, to explain more easily.

As an alternative, is it possible to get a line chart with 2 lines, where the first one is your standard one and the second only shows up when there's a period. For example, if 1-5 are seconds and P1 is period 1:

[v-frfei-msft · Accepted solution]

Hi @ispajic,

Here we can create another measure like this and add it to the line chart.

Measure = IF(MAX(Table1[Per])= "P1",CALCULATE(SUM(Table1[Column1]),ALLEXCEPT(Table1,Table1[Per])),IF(MAX(Table1[Per])="P2",CALCULATE(SUM(Table1[Column1]),ALLEXCEPT(Table1,Table1[Per])),IF(MAX(Table1[Per])="P3",CALCULATE(SUM(Table1[Column1]),ALLEXCEPT(Table1,Table1[Per])))))

Here is the result for your reference.

For more details, please check the pbix as attached.

https://www.dropbox.com/s/aux0mikx96ilbh8/Mark%20periods%20in%20a%20combination2.pbix?dl=0

Regards,

Frank

[ispajic]

This isn't a mindblowing solution, but yes, it should do 😄 Thank you!