KPI Visual Selection Help

Hi Nitin_Patil 

The Matrix visual in Power BI is ideal for displaying data in a hierarchical structure. It allows you to nest data, similar to how your organization is structured into regions, branches, and territories. You can easily expand or collapse these levels to view the detailed KPIs at each level. Additionally, the Matrix visual supports conditional formatting, which can be used to visually highlight how the actual sales figures compare against the KPI targets.
Drag and drop your hierarchical fields (Regions, Branches, Territories) into the Rows area of the Matrix visual. Then, add your sales dollar amounts and KPI targets into the Values area.

Create a matrix visual in Power BI - Power BI | Microsoft Learn
Enabled the drill down feature in the Matrix visual. This allows users to start at the top level (Regions) and drill down into more detailed levels (Branches, Territories).

Drill mode in the Power BI service - Power BI | Microsoft Learn

Set up drillthrough in Power BI reports - Power BI | Microsoft Learn
Use conditional formatting to visually indicate the status of sales against KPI targets. This can be done by setting up rules based on the values of your KPI targets and actual sales figures.

Apply conditional table formatting in Power BI - Power BI | Microsoft Learn

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.