Add combined line to Line Chart

[Anonymous]

Hi there! I have a line chart below that represents different categories across months. Is it possible to have an additional line that combines the three series in a way that adds the "missing" percent for each month for each series?

E.g. in the month of August this new line would have a value of 88% because 100%-(100%-100%)-(100%-98%)-(100%-90%).

This would for example show the total downtime across multiple pieces of equipment in a factory.

[v-deddai1-msft]

Hi @Anonymous ,

I can't download the sample data from your link. Would you please inform us more detailed information( your data and expected output (by OneDrive for Business)) if possible? Then we will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.

Best Regards,

Dedmon Dai

[FrankAT · Accepted solution]

Hi @Anonymous 

with the november update of pbid you can do it like this:

Missed = 
VAR _ValueOfA = MIN('Table'[A_])
VAR _ValueOfB = MIN('Table'[B_])
VAR _ValueOfC = MIN('Table'[C_])
VAR _Missed = 3 - (_ValueOfA + _ValueOfB + _ValueOfC)
RETURN
    1 - _Missed

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

[Anonymous]

Ah interesting idea! My current data is pivoted, so the categories are all in one column. But it's a good idea to unpivot it. Why is the november release required for this?

[FrankAT]

Hi @Anonymous 

it's interesting for the chart. You can slide the Y-axis, but for your requirements it's not necessary.

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

@amitchandak please see example here: https://gofile.io/d/mnREae

I'd be looking for an additional line that would have the value of 80