Forum Discussion
Linking Table
I make a test with your example dataset.
1. in Edit Queries
(1)select "Service1 a-Usefulness " to "Service1 e-Website and online resources" five columns, then select "Unpivot columns" (under "Transform" tab)
(2) split columns
click on column [Attribute], select split columns by delimeter
click on column [Attribute.2], select split columns by delimeter
then rename columns
[Attribute.1]->[service]
[Attribute.2.2]->[service-sub]
close&apply
2. create a measure
Measure = COUNT(Sheet6[Value])
add columns and measure in a matrix visual
3. add columns and measures in the column chart as below, you will see
Best Regards
Maggie
I make a test with your example dataset.
1. in Edit Queries
(1)select "Service1 a-Usefulness " to "Service1 e-Website and online resources" five columns, then select "Unpivot columns" (under "Transform" tab)
(2) split columns
click on column [Attribute], select split columns by delimeter
click on column [Attribute.2], select split columns by delimeter
then rename columns
[Attribute.1]->[service]
[Attribute.2.2]->[service-sub]
close&apply
2. create a measure
Measure = COUNT(Sheet6[Value])
add columns and measure in a matrix visual
3. add columns and measures in the column chart as below, you will see
Best Regards
Maggie
Thank you VERY much v-juanli-msft :)
This is amazing and would never be able to figure that out by myself.