Forum Discussion
How to split the the Column into Multiple rows.
Hey,
in the query editor, I just marked the column and from the context menu of the marked column I chose "Split Coliumn" -> "By Delimiter"
From the dialog I chose Advanced Options as shown below
This leads to the following result
Hope this is what you are looking for
Regards
Tom
Hey,
in the query editor, I just marked the column and from the context menu of the marked column I chose "Split Coliumn" -> "By Delimiter"
From the dialog I chose Advanced Options as shown below
This leads to the following result
Hope this is what you are looking for
Regards
Tom
Thank you So much Tom, its really works like champ..!
And i have one more senario, once i split the data into rows, need to calucate the percentage of the column.
Let me give you onc example:
| A | B | C | D | |
| TR | Barriers | Risk | Risk | |
| TR | Barriers | Other | Risk | |
| TR | Barriers | Both Development | Risk | |
| TR | Barriers | Cataract Development | Risk | |
| TR | Barriers | Risk | Both Development | |
| TR | Barriers | Other | Both Development | |
| TR | Barriers | Both Development | Both Development | |
| TR | Barriers | Cataract Development | Both Development |
In given example A and B is the filters, based those filter i want create a Stacked column chart on X axis for "C" values and for "Y" access i need to calculate of the %. if it is "Risk" that could be 4/8 and if it is "Both Development". 4/8. on "Y" Axis.
if this not clear let me know, so that i will share by pbix file to you.
Thank you mush for help.
Thanks,
Kapil
Hey,
I guess it would be really helpful if you could share a pbix, please start a thread, you may call is "Stacked column chart".
Regards
Tom
Thank you Tom.
I will do that.