Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

WBS issue in Power Query - cannot change type to text

Hi everyone,   I have to do some analysis on the scheduele and I'm having trouble with the WBS column. When I import the csv (or excel), this column has a data type 'Any'. I noticed that majority o...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    4 years ago

    Hi  Anonymous ,

     

    Yes,if you directly change the type to text or use Text.From,you will get a result as below:

    You could try to take below steps：

    Click "Add column">"Column From examples">Using below format:

    And you will see:

    For my sample .pbix file,pls see attahched.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my reply as a solution!

amirshiloh's avatar
amirshiloh
Advocate II
1 year ago

i found that by adding ' apostrophe sign, at the XLSX file source, before the WBS values that are in potential to have mismatch as a text format, is solve the problem on the power-bi tables.

when i tried to set theses values on the excel as "text format" it doens't has afffect on the power bi tables - whereas adding apostrophe - is the way to solve it (till the power-bi bug will be fixed)

amirshiloh's avatar
amirshiloh
Advocate II
1 year ago

using Excel formula - makes its easy  : (the WBS column is C)

run on the Excel sheet the following formula for the WBS values, apply (drag) that formula all along the WBS values on that column:

=IF(ISNUMBER(C2), IF(MOD(C2, 1)<>0, "'" & C2, C2), C2)

And later, set the column on power bi to text