Line chart- multiple lines and selections

hi,

I actually found a solution to the case with the number of lines. I just added markets to the legend in the chart, and then made a slicer next to it, which is only linked to this specific line chart. That works quite well.

Regard the other problem: Dynamic KPI selection in the line chart.

I am working with three different KPIs on the page, and will like to be able to switch manually between these three KPIs in this line chart (only on at the time). I have seen something like this other places, but would like to get guidance on how to do this.

Hi Morten_K,

 

Regard the other problem: Dynamic KPI selection in the line chart.

 

I am working with three different KPIs on the page, and will like to be able to switch manually between these three KPIs in this line chart (only on at the time). I have seen something like this other places, but would like to get guidance on how to do this.

---

If I understand you correctly, one option is create separate measures to do the corresponding calculation for each KPI first(measure1, measure2, measure3), then use SWITCH function to create a new measure to return the corresponding measure for the selected KPI, and show this measure on the line chart in this scenario.

You may need to add a new table which has a column of KPI Type if you don't have yet. Then you can use this KPI Type column as a Slicer on the report.

In addition, the formula below to create the dynamic measure is for your reference. :smileyhappy:

Measure for Selected KPI =
SWITCH (
    FIRSTNONBLANK ( 'Table1'[KPI Type], 1 ),
    "KPI1", [measure1],
    "KPI2", [measure2],
    [measure3]
)

Regards