Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I am currently working with a table visual, however for one column in particular only some of the values are displayed. The other columns in each row display as normal, whereas for this column there is a mix of values and whitespace (every column should contain a value). When I hover over the seemingly empty cell, a popup shows the value in question.
I have tried adjusting the column width, but this has not changed the output. By going to format --> values --> and turning off text wrap I am able to see the values in question, but I am curious as to why this is.
Solved! Go to Solution.
Hi @Power-MC, it might be worth using notepad ++ and the show all characters option to find out if there are any special/odd characters in the strings which are not displaying.
if you copy some of the text which is not displaying into notepad ++ and use the option above then paste an example back here we may be able to help
it may be carriage returns in your string that are making the column appear blank unless hovered over.
Hi @Power-MC, it might be worth using notepad ++ and the show all characters option to find out if there are any special/odd characters in the strings which are not displaying.
if you copy some of the text which is not displaying into notepad ++ and use the option above then paste an example back here we may be able to help
it may be carriage returns in your string that are making the column appear blank unless hovered over.
Hi @RichardJ you are right, there were special characters within the cell affecting the output, specifically #(tab)#(lf). After removing these characters, the data displays as normal. Thank you for your help.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
108 | |
101 | |
93 | |
69 |
User | Count |
---|---|
173 | |
135 | |
132 | |
101 | |
95 |