Forum Discussion
Add combined line to Line Chart
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)
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)
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?
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)