Forum Discussion

mmcanelly's avatar
mmcanelly
Icon for Helper II rankHelper II
2 years ago
Solved

Sparkline for Dynamic Measure

I have a table of dynamic measures where I want to add a sparkline for each. The table looks something like this:   Metric Name Value Metric 1 $150,000 Metric 2 4.5% Metric 3 6.0% ...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi mmcanelly 

    Please update the formula to :

    Metric Total2 =
    VAR SelectedMetric = SELECTEDVALUE (Metrics[Metric Name])
    RETURN
    if (ISBLANK(SelectedMetric),"",
    SWITCH(SelectedMetric,
    "Def $",[Total Def $],
    "CCIR",[CCIR],
    "QER",[QER]))
    Result :

    Modified pbix is attached

    If this post helps, then please consider Accepting it as the solution to help the other

    members find it more quickly

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
2 years ago

Hi mmcanelly 
Can you please share a link to dummy pbix?

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
2 years ago

Hi mmcanelly 

Please update the formula to :

Metric Total2 =
VAR SelectedMetric = SELECTEDVALUE (Metrics[Metric Name])
RETURN
if (ISBLANK(SelectedMetric),"",
SWITCH(SelectedMetric,
"Def $",[Total Def $],
"CCIR",[CCIR],
"QER",[QER]))
Result :

Modified pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other

members find it more quickly

  • mmcanelly's avatar
    mmcanelly
    Icon for Helper II rankHelper II
    2 years ago

    Thank you Ritaf1983!! This fixed the issue. Any idea why adding the if-isblank logic fixes this? I would think the original formula should give the same result, but obviously it's not.