Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Table Column with Text & Numeric Values

Hi!   I have a Power BI Desktop table that contains values that are either text  or numeric i.e. CAT Code 2160 for one record and Ida for another. When I get data from the excel spreadsheet, it is ...
Need Help
  • Gaurav_Lakhotia's avatar
    Gaurav_Lakhotia
    4 years ago

    Hi Anonymous , there is no way to store multiple data types in a single column. If you have two data types i.e., Text & Numeric then I would suggest converting that column as Text in Power Query Editor will help. 

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

    Appreciate your Kudos!!

speedramps's avatar
speedramps
Super User
4 years ago

I think I understand you

You have 2 tables.

Table1 has a column with the format "CAT Code 2160".

Table2 has a column with the format "2160".
You want to slice both with "2160".

 

Consider merging table1 and table2 into table3 with both vlaues in the same column.

Change the table3 column data type to text.

In the visual menu download the text search custom silcer.

When you search for 2160 it with find 2160, CAT Code 2160 but also 12160.

 


Remember we are BI community voluntrees so please click the thumbs-up for me taking the trouble to help you and then accept the solution if it works.  Thank you !