Segregating single Column Data into different columns

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.