Forum Discussion

PowerBIlearner's avatar
PowerBIlearner
Frequent Visitor
9 years ago

KPI with buckets

Greg_DecklerBhaveshPatelankitpatira

ImkeF Anonymous Baskar Anonymous v-haibl-msft Sean EnterpriseDNA

Hello everyone,

 

I am tryinig to create a dashboard in Power BI which is already created by my colleage in excel. I have attached the current dashboard on excel. Looks like the excel dashboard has KPIs with several buckets. In the Pending status we have a split on Age ranges. As you can see on the right side each and every range can have its threshold. Please suggest me where do I start creating similar one. I looks at several pages but I could not find anything close to this. I could see someting like barchart based on buckets but we have KPIs here with traffic lights.  I have created variables for each of those bukets like Age1_5, Age6_10 and I am not sure how to proceed now. Please help. Thank you in advance. If exactly similar one is not possible please suggest me a closer one that makes sense to executives.  Btw, the KPIs does not have to be traffic ligtt. It can be anything that shows 3 colors or guages too.

2 Replies

  • Hi PowerBIlearner,

     

    I understand that you want to implement KPI table, could you show me your transaction data and data fields? So I could provide suitable solution to achieve it.

  • Baskar's avatar
    Baskar
    Icon for Resident Rockstar rankResident Rockstar

    Hi,

     

    Can u please shared some sample data with what that u really looking for sample output.

     

     

     

    Don't worry we will do , Cheers dude