Display all metrics in one field

[Anonymous]

I have a dataset that that contains a column called Metric and it shows various KPI name (kpi1, kpi2, kpi3, kpi4, kpi5). It has a corresponding column called Value that shows the KPI value.

I'm wondering is there a way to load all these KPI's into one visual,  instead of me having to create 5 seperate visuals. Basically have Power BI generate a line chart per metric. This would be really useful as these metrics vary depending on which business unit. For example buiness "Roads" might only have 2 metrics while "Parks" could have 4.

Appreciate your feedback.

[v-jiascu-msft]

Hi @Anonymous,

Can you share a sample, please?

1. Is there any date columns? Usually, the KPI visuals have a Date field.

2. What's the expected result? 

3. Maybe you can try some custom visuals from the Market, such as PowerKPIMatrics.

Best Regards,
Dale