Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
feiDeng
Microsoft Employee
Microsoft Employee

stepped layout option not available after upload to shared space (local is enabled)

we used to have stepped layout option (enabled from local)

feiDeng_0-1712008761220.png

 

The shared workspace used to work fine until today. Seems this feature removed from matrix? I am not able to find the option as well

feiDeng_1-1712008823148.png

Please help check.

1 ACCEPTED SOLUTION
feiDeng
Microsoft Employee
Microsoft Employee

find a to fix for now. 

feiDeng_0-1712088705877.png

Hope this works.

View solution in original post

21 REPLIES 21
Dinsha
Regular Visitor

Hi, 

Yes they have removed stepped layout i guess instead this works.

Dinsha_0-1718872477066.png

Outline or Tabular works fine. (similar to stepped layout is on)

Neither compact or tabular provides a soultion if you don't want the data sunmmarised. 

v-gelobalbal
New Member

I get the same issue as well. Is there an ETA to resolve the issue?

feiDeng
Microsoft Employee
Microsoft Employee

find a to fix for now. 

feiDeng_0-1712088705877.png

Hope this works.

This is moved to Layout and style presets

bishnupc_0-1721926312472.png

 

I'm not certain this represents the same issue originally posted, but it does seem to be related...

Background:
 - All our Power Bi reports are developed in the desktop app.
 - I use the Matrix visual extensively, sometimes with Stepped Layout "on", sometimes with it "off", depending on the report need.
 - There has been no issue with this functionality until recently, when consumers started 'complaining' that something was changed in a specific report and no one likes this change.
The Issue:

 - There are 2 matrices in this report that specifically have the Stepped Layout option turned "off".  

 - However these matrices now display in the service as though the Stepped Layout is "on".  This is NOT acceptable for this report.
 - I downloaded the PBIX from the service and opened it in the desktop - these matices both display exactly as they should, with the Stepped Layout "off".
 - I deleted the report from the service and republished from the desktop, to no avail.

 - The service does not have an "on/off" setting for Stepped Layout per se.
A Possible (temporary) Solution:

 - With the report open in Edit mode in the Power BI service...
    - Select the matrix visual to be 'fixed'
    - Select Format visual in the Visualizations pane.

    - Open Layout and style presets under the Visual option.

    - Select Tabular under Layout.

The strange thing about this "work-around" is that the Desktop app doesn't seem to have the Layout option under Style presets, so apparently this is another step to be taken after publishing the report to the service.


The other solution I read in this thread seems to show how to change the Style Layout to enhance the look of having Stepped Layout "on" but reading some of the other comments, I thought perhaps the issue is that they were wanting to know how to turn "off" Stepped Layout in a matrix.

Sadly, this did not fix the issue for me. The toggle for turning stepped layout on and off has now also disappeared from the desktop version. Now it has the new Layout and style presets menu, but neither the tabular or the very similar Outline layout makes it look the way it did before the update.

Does the "compact" layout option work? I found that it is very similar or the same as turning stepped layout off.

Nope, it does not for me. I want the data in a tabular format where the item labels are repeated across all rows. This can achieved only by turning stepped layout off.

Hello @nx_protium , as your post was added to a separate question that has been accepted as a solution, would you please create a new post and reference this forum thread in the new post.

 

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

Hello @Kimber , as your post was added to a separate question that has been accepted as a solution, would you please create a new post and reference this forum thread in the new post.

 

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

Thank you! This works. 

I have this same issue with Power BI online only starting yesterday and see that you had it 6 weeks ago! Has there been a fix? I don't understand the solution you proposed. Is the Sparse style and Compact layout options supposed to look like a matrix with Stepped Layout off?

feiDeng
Microsoft Employee
Microsoft Employee

Is there a ETA to fix this issue? Some of our table use this option is not readable for now. 

Also is there a way we can downgrade to previous version for power BI service?

 

Thank you.

Anonymous
Not applicable

Hi @feiDeng ,

I test it in my environment, it works well.

Power BI Desktop:

vbinbinyumsft_0-1712023892800.png

 

Power BI Service Pro License Mode Workspace:

vbinbinyumsft_1-1712023995041.png

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hello I have the same issue, can someone provide a solution? 

thank you

Zoey

Thanks Binbin,

 

It seems I am using a different version 

feiDeng_1-1712033752577.png

 

power bI service

feiDeng_0-1712033711502.png

Could you try those newer versions? Thank you for looking at this. It was working fine last week. So I wonder if something with the new version. Thank you again. 

Anonymous
Not applicable

Hi @feiDeng ,

I test in the newer version, for Power BI Desktop, could find "Stepped layout" option, but could not find it in Power BI Service.

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Similar issue here, I have a report that has a matrix visual that works well in power bi desktop and is not working when published online. Is there an ETA as to when this missing option would be restored or the visual fixed for the Online Power BI Service? Below is a screenshot of the Matrix.

 

Screenshot 2024-04-02 104230.png

 

 

 

 

 

 

 

 

Thanks,

Yogesh

right. I have the same obeservation. It works fine from the desktop version but not working on the Power BI service.

 

Thank you.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.