Forum Discussion
Data Display issue in PowerBI Report
Hi Tirtha
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hello danextian thank you very much for your response. Its really insightful and this is what I have thought but you have given a lot more context. Yes, that is correct I have two three rows with abc.startTime, one with upper T in Time and one with Lower "t" in time. But these values are critical to be retained as they are in the source. Is there any way to display the values as they are?
Thanks again.
You can add a column that converts the text to binary and then to a readable Base64 encoded string if you want to differentiate a row with the same value from another. However, VertiPaq will still kick in for the original text.
[Original Text] & "_" & Binary.ToText(Text.ToBinary([Original Text]), BinaryEncoding.Base64)
Also, do not attempt to use DAX to extract the text before _ in the screenshot below as VertiPaq, again, will still kick in.