Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Add combined line to Line Chart

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" perce...
Need Help
Show and Tell
Tips and Tricks
  • FrankAT's avatar
    FrankAT
    5 years ago

    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)

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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