Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register 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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
76 | |
55 | |
37 | |
34 |
User | Count |
---|---|
99 | |
56 | |
53 | |
44 | |
40 |