Forum Discussion

pcolas's avatar
pcolas
Frequent Visitor
6 years ago

Display multiple KPIs in one chart and matrix

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.

Need Help

4 Replies

  • v-alq-msft's avatar
    v-alq-msft
    Community Support
    6 years ago

    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

  • pcolas's avatar
    pcolas
    Frequent Visitor
    6 years ago

    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