Forum Discussion

jwessel's avatar
jwessel
Helper II
2 years ago

Matrix visual shows text values as numeric

I have an Excel spreadsheet where I have the cells in the spreadsheet formatted as "Text". Additionally, my transformation process for loading the data ensures that the columns for all of these cell...
General Comment
Need Help
Tips and Tricks
mussaenda's avatar
mussaenda
Community Champion
2 years ago

Hi jwessel 

 

Convert it to percentage in desktop, not in power query. it is showing 0 because it is being treated as decimal 0.45 (i assume) try converting it and it will add the % automatically

  • jwessel's avatar
    jwessel
    Helper II
    2 years ago

    Hi mussaenda ,

    thanks for the prompt follow-up.  The issue I'm having is that I just want to show the exact literal text value that was entered into the Excel source data.  The data entered into these fields in Excel could be either percentages literals, like "45%" or they could be whole numbers depending on the row item in the source Excel.  I have all my Power BI columns set to Text format and I also have all my Excel cells set to text format as well.  That seems be getting overridden either by Excel or Power BI when the data gets loaded.