Display multiple KPIs in one chart and matrix

[pcolas]

Hello community,

I have calculated 7 KPIs in my data. Each one of these KPIs have its own column.

My problem is that I cannot find a way to use a visualization that can show all these KPIs in one chart and matrix.

The chart and matrix should include:

1. ATD (date)

2. Number of shipments (count and %)

3. KPI 1, 2, 3, 4, 5, 6 and 7. (Good, Bad and Missing data)

Is this possible?

Thank you for your assistance.

[pcolas]

Hi again,

Thank you for your input. I still not there yet.

Basically, the data looks like this:

Now the matrix should look like this:

Any thoughts? 

Thank you

[v-alq-msft]

Hi, @pcolas 

Based on your description, It is suggested that you may use Multi KPI from MarketPlace, which is for presenting a key performance indicator along with a variety of supporting information.

Here are the key features include:

• KPI trend over time: hover-over the main chart to see a KPI for each date.

• Rich Formatting Options: set alternate titles, and tooltips, font sizes, colors, background colors.

• Numerous Chart Features: multi KPI support number types, precision, Y-axis tick marks, and hover-over tooltips.

• Sparkline Interpolation: Interpolate sparkline values to get rid of noisy points.

• Auto-Scaling: design a larger tile in your report with rich details. After pinning it to a Power BI Dashboard, you may resize it to smaller versions of the tile without losing essential details.

Best Regards

Allan

[amitchandak]

You can use Multi-Row Card

Or Refer -Multi KPI 

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381763?src=office&tab=Overview

[pcolas]

Hi @amitchandak and @v-alq-msft 

Any suggestions?

Thank you!