Forum Discussion
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 ...
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!!
That worked! Thank you so much. One more question well I have your ear. I have a dropdown slicer and when I hover over the available items, the dropdown disappears. I have to click the slicer and then it will allow me to scroll through the dropdown. Any suggestions?
Mike
Gaurav_Lakhotia
Helper III
Helper IIIAre you using any shape or something behind the slicer?