Forum Discussion

AV_04's avatar
AV_04
Helper I
3 years ago
Solved

Power BI Visual Help

Hi Team,

 

I have the below table:

 

DeptDescriptionNameLocationAcheivement 
MedicalAwarded for best in medicalMr AUSAAchieved in Med 
AdminAwarded for best in adminMr BCanadaAchieved in effective management of Admin 
ITAwarded for best in ITMr CUSAAchieved in effective management of IT 
MechanicalAwarded for best in MechanicalMr DUSAAchieved in effective management of Mech 

 

My desired visual output should be like below:

 

DescriptionAcheivementNameLocation
 Medical  
Awarded for best in medicalAchieved in medMr AUSA
 Admin  
Awarded for best in medicalAchievedMr BCanada
 IT  
Awarded for best in medicalAwarded for best in ITMr CUSA
 Mechanical  
Awarded for best in medicalAwarded for best in ITMR DUSA

 

I want the department to be at the top of every records. Could anyone help me to get me to the desired output? I have also attached the below image if the above desired table format isn't clear.

 

 

 

Need Help

5 Replies

  • rajulshah's avatar
    rajulshah
    Resident Rockstar
    3 years ago

    AV_04 ,

     

    I believe the values of Description column in the output provided is incorrect. Can you please confirm?

    • AV_04's avatar
      AV_04
      Helper I
      3 years ago

      Hi Rajulshah,

       

      They are dummy data, the overall structure of the output is the same. The values are mocked

    • rajulshah's avatar
      rajulshah
      Resident Rockstar
      3 years ago

      AV_04 ,

       

      Do you want your output to look like below?

       

      • AV_04's avatar
        AV_04
        Helper I
        3 years ago

        yeah, this would be helpful. can you share the pbix with me if possible. thank you!