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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
kalikumar
Helper II
Helper II

Matrix Visual shows Two Rows?

Hi All,

     

         In this below snips Matrix Visual rows have three field. But It shows In One Rows like + and -.
         But I need to show the last field in different rows like the 12,16,... They are shown in the addition new row.

         It is Possible?

         Please Help me.

         Thanks in Advance. 

 

kalikumar_1-1697451356379.png

 

 

1 ACCEPTED SOLUTION
Anand24
Super User
Super User

Hi @kalikumar ,

You will need to disable the "Stepped Layout" format property. It will be enabled by default.

Anand24_0-1697452174937.png

PBI_SuperUser_Rank@1x.png  

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

Proud To Be a Super User !!!
LinkedIn

 

 

View solution in original post

6 REPLIES 6
Anand24
Super User
Super User

Hi @kalikumar ,

You will need to disable the "Stepped Layout" format property. It will be enabled by default.

Anand24_0-1697452174937.png

PBI_SuperUser_Rank@1x.png  

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

Proud To Be a Super User !!!
LinkedIn

 

 

Hi @Anand24 

        Thanks for responese. 

         This is the really think i need. But It works Correctly when using two filed.

         But I need the first two rows same default format. The Third filed only shows new row in the visual.

         It is Possible?

@kalikumar ,
If that's what you want, you should enable Stepped layout but move the numeric field(field having 12, 16, etc.) from Rows to Values.

From your initial screnshot, it seems you have put the numeric field into Rows which seems to be the mistake.
PFB screenshot with what you need to do with stepped layout disabled:

Anand24_0-1697453147082.png

 

PBI_SuperUser_Rank@1x.png  

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

Proud To Be a Super User !!!
LinkedIn

@Anand24  , 

          It's fine But the row field in matrix visual is freezed. But the value field is not freezed.

          I need the numberic field also in row field.

@kalikumar ,
It is impossible to achive the format you want if you keep numeric field in rows instead of values.

PBI_SuperUser_Rank@1x.png  

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

Proud To Be a Super User !!!
LinkedIn

Ritaf1983
Super User
Super User

Hi @kalikumar 
You can "open" all hierarchies by drill down option and switch off the "+" if you need it :

Ritaf1983_0-1697452123592.png

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.