I have these tables and as you can see the one on left is missing a border on the cell left side
how can i make this
what is the cause of this ?
Hi @Mustaf
Please refer to the documentation below for cell formatting, this might be helpful for you.
I’m having the same issue with my Pivot table. I’m using it to show a summary of counts. I tried using vertical borders to divide the counts and the cell row is missing the left border as seen here:
I tried other border settings and could not get the left border to show up.
In case I accidentally changed a setting to cause this issue, I created a new Pivot table, added one field in the values section with Count distinct and it is missing the left border as seen here:
How can I get the left border on the left most cell to show up?
I decided to try recreating this in Arena in case it helps anyone trying to solve this.
Missing Left Border Example
I recreated both of my examples from above that show the missing left border on the cell row:
Hi @MikeB,
That looks like a visual bug. As a workaround, create a calculated field to calculate the distinct count and add it to a table instead of a pivot table. That seems to work for me.
Hello @David_Wong,
Thank you. That workaround fixes the missing border issue.
It appears to have some other issues/inconveniences. The Table doesn’t seem to have the Column Width property so we will need to manually adjust with widths.
A more inconvenient one is that I can’t make the fonts as large without getting the “Container is too small” error. Even if I adjust the Row height to be shorter where everything would fit, I have to make the visual’s height taller than desired to show the data.
Example with background colors set to show row heights:
Visual Height 98:
Visual Height 99:
In the Pivot Table, I can use this font size with a control height of 80, which is what I was hoping to use.
Do you know if there is a way to create a shorter table without this issue?