Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Question on Conditional Column as Parameter

I am working on a skillset survey, and the rating is know of, beginner, intermediate, advanced and expert, and I have used a conditional column to assign values 1, 2, 3, 4, and 5. I would like to kee...
Need Help
Tutorial Requests
mussaenda's avatar
mussaenda
Community Champion
6 years ago

hi Anonymous 

 

I didn't get what you really need.

Do you want to show 1 as beginner, 2 as intermediate and so on?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Mussaenda,

Yes 🙂 I've added some screenshots to my previous reply. I hope it might explain better.

  • mussaenda's avatar
    mussaenda
    Community Champion
    6 years ago

    Anonymous,

     

    Thanks for the screenshots. Now I understand you better.

    But please provide a sample data that can be copied. Thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Here's a link to download an example:

      LINK  

      • mussaenda's avatar
        mussaenda
        Community Champion
        6 years ago

        Anonymous,

         

        I have attached the pbix link from what I understood from your explanation.

        Hope this helps.

        https://gofile.io/?c=4Eaksj

         

        BTW, I have changed your sample data just to see differences.

         

        NameDepartmentProject IPMA - AProject IPMA - BProject IPMA - CProject IPMA - DProject PMP Project ITSMProject ScrumProject Prince 2 - PrincessProject Prince 2 - Change Management
        MichaelDevelopment  Know of  Advanced Beginner  
        KevinConsultancyAdvancedIntermediateBeginnerKnow of   Know of  
        Michael 2Development  Know of  Advanced Intermediate  
        Kevin 2ConsultancyKnow ofBeginnerIntermediateAdvanced  Advanced  
        Michael 3Development  Expert Intermediate Beginner  
        Kevin 3ConsultancyIntermediateBeginnerAdvancedAdvanced  Expert