Forum Discussion
KPI level matrix table
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?
I was able to solve it later on forgot to update here
10 Replies
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
Can you please elaborate your ask, what do you mean by KPI level details?
A matrix that can show the KPI at multiple hierarchies and lets me drill down from summary to detail
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!
What kind of KPI detail are you after, conditional formatting/icons on values, or targets vs actuals with variance?
Hi Kedar_Pande , I’m mainly looking for targets vs. actuals with variance.
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-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...Thank you.
Hi powerbidev123,
Checking in to see if your issue has been resolved. If not provide the sample data with the expected output.
Thank you.
I was able to solve it later on forgot to update here
