Forum Discussion
splitting a column with answers from multiplechoice question
Hi, Anonymous
Thanks for your quick response!
According to your screenshot, you split the column to many columns. For your need , i think teh besy way is not like this.
This is my test data:
(1)We do not split to more columns just one , we can click "Custom Column" and enter:
(2)Then we can remove the [Type] column:
(3)Then we can "expand to new rows":
(4)Then we can apply the data to the Power Bi Desktop, then we can put the field on the visual and we can meet your need:
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
I can't figure it out, my version is Dutch. I'm trying to adding an example from the original file. When I download the original file, I can choose answers in text or the serial number of the answer. How I get this sample here? I have a pbix I get response the file type pbix is not supported
let
Bron = Excel.Workbook(File.Contents("D:\Nelleke\Documents\Downloads\dossiers.xlsx"), null, true),
Export_Sheet = Bron{[Item="Export",Kind="Sheet"]}[Data],
#"Type gewijzigd" = Table.TransformColumnTypes(Export_Sheet,{{"Column1", type text}, {"Column2", type text}}),
#"Headers met verhoogd niveau" = Table.PromoteHeaders(#"Type gewijzigd", [PromoteAllScalars=true]),
#"Type gewijzigd1" = Table.TransformColumnTypes(#"Headers met verhoogd niveau",{{"Naam", type text}, {"Type", type text}}),
#"Kolom gedupliceerd" = Table.DuplicateColumn(#"Type gewijzigd1", "Type", "Type - Kopie"),
#"Kolom splitsen op scheidingsteken" = Table.SplitColumn(#"Kolom gedupliceerd", "Type - Kopie", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), {"Type - Kopie.1", "Type - Kopie.2", "Type - Kopie.3", "Type - Kopie.4"}),
#"Type gewijzigd2" = Table.TransformColumnTypes(#"Kolom splitsen op scheidingsteken",{{"Type - Kopie.1", type text}, {"Type - Kopie.2", type text}, {"Type - Kopie.3", type text}, {"Type - Kopie.4", type text}})
in
#"Type gewijzigd2"
It's in dutch... What is the best and easy way to share my report?
Community SupportHi, Anonymous
Thanks for your quick response!
According to your screenshot, you split the column to many columns. For your need , i think teh besy way is not like this.
This is my test data:
(1)We do not split to more columns just one , we can click "Custom Column" and enter:
(2)Then we can remove the [Type] column:
(3)Then we can "expand to new rows":
(4)Then we can apply the data to the Power Bi Desktop, then we can put the field on the visual and we can meet your need:
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thanks I'm so happy that now I have fixed it. This is exact the solution. I did not understand in first sight but now it's working! Loved it.😀👌