KPI level matrix table

[powerbidev123]

Hi All,I am searching for a matrix table that would provide me with a KPI level of details. Would i need to look for it in the custom visuals section or some solution can be found in the default visuals itself?

[v-saisrao-msft]

Hi @powerbidev123,

Checking in to see if your issue has been resolved. If not provide the sample data with the expected output.

Thank you.

[powerbidev123 · Accepted solution]

I was able to solve it later on forgot to update here

[Kedar_Pande]

What kind of KPI detail are you after, conditional formatting/icons on values, or targets vs actuals with variance?

[powerbidev123]

Hi @Kedar_Pande , I’m mainly looking for targets vs. actuals with variance.

[v-saisrao-msft]

HI @powerbidev123,

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? 

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Thank you.

[danextian]

I am not sure what you exactly want but this could be what you're looking for 

https://marketplace.microsoft.com/en-us/product/WA104381299?tab=Overview

[tharunkumarRTK]

@powerbidev123 

Can you please elaborate your ask, what do you mean by KPI level details?

[powerbidev123]

A matrix that can show the KPI at multiple hierarchies and lets me drill down from summary to detail

[tharunkumarRTK]

@powerbidev123 

Power BI default Matric visual allows you to add row and column hierarchies.

https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-matrix-visual

So if you expectation is beyond these capabilities then please do share your expected result. 

Also, if your expected is to see the underlying data that a Measure used to calculate the value then you can use DEATILROWS property. 

https://www.sqlbi.com/articles/controlling-drillthrough-using-detail-rows-expressions-in-dax/

Connect on LinkedIn

read my blogs here: https://www.techietips.co.in/

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

[krishnakanth240]

Hi @powerbidev123 

Can you share a sample output you want to view