Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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.
1. Create two new irrelevant tables as slicer.
Characteristic of Skill = CALCULATETABLE(VALUES('Table'[Characteristic]),FILTER('Table','Table'[Type]= "Skill"))
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.
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
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.
1. Create two new irrelevant tables as slicer.
Characteristic of Skill = CALCULATETABLE(VALUES('Table'[Characteristic]),FILTER('Table','Table'[Type]= "Skill"))
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.
It's my pleasure to help you resolve this.😊
Best Regards,
Xue Ding
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |