Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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
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
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:
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
This isn't a mindblowing solution, but yes, it should do 😄 Thank you!
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
63 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |