The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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