Forum Discussion

mmcanelly's avatar
mmcanelly
Helper 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
Super User
2 years ago

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

Ritaf1983's avatar
Ritaf1983
Super 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
    Helper 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.