Continuous Line Graph Issue

[D_Brandon_E]

Hi everyone,

I am wanting a line graph visual with time(0-120 seconds) as my x-axis, and then volts (0 to -2) on my y-axis. Where my line graph is a bit different from other line graphs I have used in the past is that my legend is about 14 categories long, but I need all of them on the same line. The dataset is for testing of voltage interactions and over the 2 minutes, the test will All on (all categories set to on, but signified in its own category of "All on") for 5 seconds, then only one of the testing companies will go on (all the rest off), then All on for 2 seconds, then the second company will test. Since all of this is on the same timeline and the dataset reflects this with a time column, and then an Status column (Legend, which category is on at the time) and then a volts column. The problem I am having is that because the line graph is set to continuous, when All on goes off, it does the right thing and goes to the first company, but when All on comes on again, the graph connects from when the All on last went on to where is starts up again. I may not be explaining well, but you will see below in the graph. I have attached the dataset as well. 

How can I get the All on to not connect to each other and just allow it to flow from one process to another. Categorical does not work like we want it to and Continuous gets us so close, but only for this one issue. I can do this in Excel just fine, but not in Power BI. I included the Excel graph for what it needs to look like in Power BI.

Excel Graph

Power BI Graph

I also attached the .pbix test file

https://1drv.ms/u/s!Ak_d4nobK-jeinYdNHUtL6j6Wx6C

[parry2k]

@D_Brandon_E well in that you can create a custom tooltip page and make it the way you want to see it.

Using report tooltip pages in Power BI - Power BI | Microsoft Docs

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[parry2k · Accepted solution]

@D_Brandon_E unfortunately it is not that straight forward but doable, solution is attached. tweak it as you see fit, and here is the output in the Power BI

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[D_Brandon_E]

@parry2k 

That is great, thanks. I did have one question for you though, when I hover over the line for say, Cycle 5 of 12, the tooltip shows the Cycle 5 of 12 value, but also the "All On" value. Technically, based on the process of the test that the company performs, All On is not actually "On" and just Cycle 5 of 12. I am guessing All On value is showing is because of "Continuous". Is there a way to only have the Category show that is actually being performed (Should only be one at a time). Basically, when one category(test process) ends, another begins.