Forum Discussion
Power ParticipantSpaces inserted into matrix when published to service
This is actually a preoblem with desktop not the service. Somehow all out matrix have total set to Top in most cases. But when I view them in Power Bi desktop the Row Subtotal is set to Bottom , even when the subtotal is clearly Top??? I have now to reset all these to Top. We have lots of these.
Row subtotal set to Bottom, but is in fact showing Top??
Hi gooranga1
I tested the issue you raised and did not encounter the same situation.
Here I offer you some suggestions, please try the following:
Ensure that both Power BI Desktop and Power BI Services are up to date. Discrepancies can sometimes occur if there are differences in versions.
Here is the version I use.
Look for any changes in the data model or the data source that might have occurred around the time the issue started.
Verify if there are any visual-level filters applied that might be causing the blank spaces to appear after publishing.
Here I would suggest you to create a simple visual and publish it to the service to see if there are any issues.
If no issues are encountered then republish your report.
If you still have problems, it is best to provide the pbix file and be careful to delete sensitive data.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Power Participantthis isn't happening to just one report, it's everything. Hundreds of matrixes all affected. The only way to adjust it is to edit the report in the service and change the Layout and Style Presets to Tabular from Outline as FabioL99 suggested. But I cannot find that option in desktop? And changing all the individual matrixes to this would take us years so isn;t an option?
MS have changed something on the service that has messed this up and it needs rectifying. I have also opened a ticket.
Hi gooranga1
I noticed.
If you've already submitted a ticket, they can offer more targeted advice.
Regards,
Nono Chen