Segregating single Column Data into different columns

[Harinihemanth06]

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	Skill	Engilsh
12-11-2017	kal	Certification	A103
13-11-2017	Har	Certification	A103
14-11-2017	Rit	Certification	A400
15-11-2017	suj	Certification	A400
16-11-2017	hem	Skill	Hindi
17-11-2017	suj	skill	Tamil
18-11-2017	Rit	Qualification	VLIT
22-11-2017	suj	Qualification	LIT
23-11-2017	hem	Qualification	VLIT
24-11-2017	vin	Skill	Tamil
25-11-2017	vin	Certification	A200
26-11-2017	kal	Qualification	LIT
27-11-2017	che	Certification	A200
28-11-2017	che	Qualification	VLIT
29-11-2017	sun	Skill	Hindi
30-11-2017	sun	Certification	A103
01-12-2017	man	Certification	A400
02-12-2017	sow	Certification	A200

I want Characteristic to be seperated according to type. i.e I want 3 slicers for Certification and only corresponding Characteristic ,Skill only Corresponding Characteristic and Qualification And Characteristic .

For example if I have select "Certification" as "A400" it should show number of resources and then from "skill "if i Select - "Hindi" then the resources should be further filtered.

Any input will be helpfull

[rajulshah]

Hello @Harinihemanth06 ,

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

[Harinihemanth06]

Hi @rajulshah 

Am looking similar result

Resource	Tpe	colum1	column2	column3	column4	column5
Har	Skill	English	Certification	A103	Qualification	Nill
Rit	Skill	Hindi	Certification	a400	Qualification	VLIT
Kal	Skill	English	Certification	a400	Qualification	LIT
Suj	Skill	Tamil	Certification	A400	Qualification	LIT
vin	Skill	Tamil	Certification	a200	Qualification	nill

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 · Accepted solution]

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.

[Harinihemanth06]

@v-xuding-msft Thank you for the solution

[v-xuding-msft]

Hi @Harinihemanth06 

It's my pleasure to help you resolve this.😊

Best Regards,
Xue Ding