Forum Discussion
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...
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 - _MissedWith kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)
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
Community Champion
Community ChampionHi 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)