Border in matrix visual not visible in PowerBI.com

[BK1234]

In Power BI desktop I have set an orange line in a matrix visual with option Visual - Grid - Border. It's visible in desktop but when I publish to .com it's not visible. How can I get it visible in .com?

This is how it looks in desktop:

This is how it looks in .com:

[v-jingzhang · Accepted solution]

Hi @BK1234 

The option Visual - Grid - Border only decides its global color and width. It doesn't decide the border position. Please refer to the following options under Column headers and Row headers to check whether the border positions are selected correctly in the service. 

The left is the format pane in service and the right is New format pane in Desktop. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[v-jingzhang · Accepted solution]

Hi @BK1234 

Click Edit to enter editing mode and check that options in Format pane. You can also change the format in the service and save report from File > Save. 

Jing

[amitchandak]

@BK1234 , Just clear, Browser cache -> refresh and try again

Republish -> Browser cache -> refresh and try again 

If these do not work, check if any user recently reported any issue - https://community.powerbi.com/t5/Issues/idb-p/Issues

[BK1234]

@amitchandak Thank you for your reply.

I tried deleting cache multiple times. Before/after publishing but it didn't work. Also tried Firefox instead of Chrome but the result is the same. There is an issue maybe relating to this, so I added my comment there: https://community.powerbi.com/t5/Issues/Banded-Rows-on-Matrix-Visualisation-not-working-correctly-on...

[v-jingzhang · Accepted solution]

Hi @BK1234 

The option Visual - Grid - Border only decides its global color and width. It doesn't decide the border position. Please refer to the following options under Column headers and Row headers to check whether the border positions are selected correctly in the service. 

The left is the format pane in service and the right is New format pane in Desktop. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[BK1234]

Hi v-jingzhang,

Thank you for your reply! I checked the options in desktop and they are allready set like you said but they are not visible in .com.

[v-jingzhang · Accepted solution]

Hi @BK1234 

Click Edit to enter editing mode and check that options in Format pane. You can also change the format in the service and save report from File > Save. 

Jing

[BK1234]

Hi @v-jingzhang 

Ah, I didn't know that was even possible. But in the service the options were not checked. I checked them, saved and now the lines are visible in .com. Thank you!
I'm wondering: why is it that the options in the service are not the same as my desktop-options? Is it because we define the orange line in a .json-theme-file? Do we have to use a different command there, maybe? And if I publish a new version from desktop, do I have to change the options again in the service?

This was how the checkboxex were checked:

[v-jingzhang]

Hi @BK1234 

Not sure if this is a New Format pane issue. Today I downloaded the latest Desktop version (2.104.941.0 64-bit (April 2022)) and I found the Border option has been moved to under Grid option. Below image is captured from the new version. And by default the grid lines are not selected. 

As the New Format Pane feature is still in preview and is not stable at present, you can try switching back to the old format pane and publish the report again to check the result. Go to File > Options and settings > Options > Preview features > uncheck New Format pane. Close Power BI Desktop and restart it again. Power BI Service also uses the old format pane so perhaps the problem will not occur. You could have a try!

Jing

[BK1234 · Accepted solution]

Hi @v-jingzhang,

I tried using the old format pane by checking out the preview feature. Closing and opening desktop and published the report but the line is still gone. 

Then I opened the report again in the service. Added the lines and then downloaded the pbix from PowerBI.com (while the lines where visible). I opened the downloaded file in desktop and published the report again. Now the lines are visible. So now I have a pbix-file which has the lines visible in .com and in desktop. It's a workaround but it prevents me from checking the checkboxes in the service, everytime I publish the report again.

Thanks again for all your help!

Betty