Forum Discussion

Harinihemanth06's avatar
Harinihemanth06
Microsoft Employee
6 years ago
Solved

Segregating single Column Data into different columns

Need help with Segregating single Column Data into different columns Date Resource Type Characteristic 12-11-2017 Har Skill English 13-11-2017 Rit Skill Hindi 14-11-2017 Kal S...
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    Hi Harinihemanth06 ,

    For your requirement, you need to create multiple tables as slicers. If still use the original column as slicers, the values will be always filtered by other slicers. 

    The following formulas just for one type. The other types are same as them. For more details, you could reference my sample.

    • For type of Skill

    1. Create two new irrelevant tables as slicer.

    Characteristic of Skill = CALCULATETABLE(VALUES('Table'[Characteristic]),FILTER('Table','Table'[Type]= "Skill"))

    Create manually

    2. Create measures.

    Skill1 = SELECTEDVALUE(Skill[Skill])

Measure 2 = 
VAR a =
    CALCULATE (
        MAX ( 'Table'[Characteristic] ),
        FILTER ( 'Table', 'Table'[Type] = [Skill1] )
    )
VAR b =
    CALCULATE (
        MAX ( 'Table'[Characteristic] ),
        FILTER (
            'Table',
            'Table'[Characteristic]
                = SELECTEDVALUE ( 'Characteristic of Skill'[Characteristic] )
        )
    )
RETURN
    IF (
        ISFILTERED ( Skill[Skill] ),
        IF (
            ISFILTERED ( 'Characteristic of Skill'[Characteristic] ),
            b,
            a
        ),
   b
    )

    Best Regards,

    Xue Ding

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

rajulshah's avatar
rajulshah
Resident Rockstar
6 years ago

Hello Harinihemanth06 ,

 

Please provide the sample result of the data that you posted.

  • Harinihemanth06's avatar
    Harinihemanth06
    Microsoft Employee
    6 years ago

    Hi rajulshah 

     

    Am looking similar result

     

    ResourceTpecolum1column2column3column4column5
    HarSkillEnglishCertificationA103QualificationNill
    RitSkillHindiCertificationa400QualificationVLIT
    KalSkillEnglishCertificationa400QualificationLIT
    SujSkillTamilCertificationA400QualificationLIT
    vinSkillTamilCertificationa200Qualificationnill

     

    My requirement is that I need to have multislicer selection slicer on Certification,skill and Qualification and three different slicers for characteristic selection 

    • v-xuding-msft's avatar
      v-xuding-msft
      Community Support
      6 years ago

      Hi Harinihemanth06 ,

      For your requirement, you need to create multiple tables as slicers. If still use the original column as slicers, the values will be always filtered by other slicers. 

      The following formulas just for one type. The other types are same as them. For more details, you could reference my sample.

      • For type of Skill

      1. Create two new irrelevant tables as slicer.

      Characteristic of Skill = CALCULATETABLE(VALUES('Table'[Characteristic]),FILTER('Table','Table'[Type]= "Skill"))

      Create manually

      2. Create measures.

      Skill1 = SELECTEDVALUE(Skill[Skill])

Measure 2 = 
VAR a =
    CALCULATE (
        MAX ( 'Table'[Characteristic] ),
        FILTER ( 'Table', 'Table'[Type] = [Skill1] )
    )
VAR b =
    CALCULATE (
        MAX ( 'Table'[Characteristic] ),
        FILTER (
            'Table',
            'Table'[Characteristic]
                = SELECTEDVALUE ( 'Characteristic of Skill'[Characteristic] )
        )
    )
RETURN
    IF (
        ISFILTERED ( Skill[Skill] ),
        IF (
            ISFILTERED ( 'Characteristic of Skill'[Characteristic] ),
            b,
            a
        ),
   b
    )

      Best Regards,

      Xue Ding

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