Forum Discussion

Ravindra_'s avatar
Ravindra_
Frequent Visitor
1 year ago
Solved

Issue with Case Conversion in Power BI Table View

Dear Microsoft Support Team, I hope you are doing well. We have encountered an issue in Power BI where the case of certain strings is being altered when switching to Table View. This behavior is une...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    Hi Ravindra_ 

    Power BI automatically normalizes text case when loading data, treating "English" and "enGLISH" as the same value and picks whatever gets loaded first. You convert the text to binary and then the binary format to text and append it to the original. Extracting the actual text in DAX will, however, return just the first version that gets stored.

    Here's s sample custom column:

    let 
toBinary = Text.ToBinary([TextColumn]),
toText = Binary.ToText(toBinary)
in [TextColumn] & "_" & toText

     

     

danextian's avatar
danextian
Super User
1 year ago

Hi Ravindra_ 

Power BI automatically normalizes text case when loading data, treating "English" and "enGLISH" as the same value and picks whatever gets loaded first. You convert the text to binary and then the binary format to text and append it to the original. Extracting the actual text in DAX will, however, return just the first version that gets stored.

Here's s sample custom column:

let 
toBinary = Text.ToBinary([TextColumn]),
toText = Binary.ToText(toBinary)
in [TextColumn] & "_" & toText