Forum Discussion
Solution SageKPI 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
- danextian
Super User
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
Can you please elaborate your ask, what do you mean by KPI level details?
powerbidev123A matrix that can show the KPI at multiple hierarchies and lets me drill down from summary to detail
- tharunkumarRTK
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!
- 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-msftCommunity Support
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.
- 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
I was able to solve it later on forgot to update here
