Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Icon for Impactful Individual rankImpactful Individual
2 years ago
Solved

custom table

can it possible to show below in power bi, i am not sure which visual we can use for this  
Need Help
  • mickey64's avatar
    mickey64
    2 years ago

    Step 0: I use these data below.

     

    Step 1: I add a ’Flag' column on Power BI Desktop.

        Flag = IF([Value]>=9,"Promoters (9-10)",IF([Value]>=7,"Passives (7-8)","Detractors (0-6)"))

     

    Step 2: I make a matrix.

     

mickey64's avatar
mickey64
Icon for Super User rankSuper User
2 years ago

Step 0: I use these data below.

 

Step 1: I add a ’Flag' column on Power BI Desktop.

    Flag = IF([Value]>=9,"Promoters (9-10)",IF([Value]>=7,"Passives (7-8)","Detractors (0-6)"))

 

Step 2: I make a matrix.