Bug: Expand down all one level in hierarchy - not publishing correctly to PowerBI.com service

[Brian_M]

When you expand the rows in a hierarchy in Matrix visualisation to show all the values in the next level down in the hierarchy, you see a result such as this.

Country1

  State1

  State2

Country2

  State3

  State4

When you publish this report to PowerBI.com service, the report incorrectly shows:

Country1

Country2

when the desired outcome is to show the expanded hierarchy as per the PBI Desktop report.

When I try a workaround to Edit the report in the service, expand the hierarchy and then Save the report again in the service, the expanded state is not saved.

[Brian_M · Accepted solution]

I've just deleted the report and dataset from the service and re-published and the correct behaviour is restored. I was having sporadic issues with changes made on the powerbi.com not saving correctly too. Perhaps there was a blip in powerbi.com service and/or some kind of caching glitch.

You can close this issue.