The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Solved! Go to Solution.
Hi @kalikumar ,
You will need to disable the "Stepped Layout" format property. It will be enabled by default.
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 !!! |
Hi @kalikumar ,
You will need to disable the "Stepped Layout" format property. It will be enabled by default.
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 !!! |
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:
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 !!! |
@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.
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 !!! |
Hi @kalikumar
You can "open" all hierarchies by drill down option and switch off the "+" if you need it :
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
81 | |
81 | |
48 | |
41 |
User | Count |
---|---|
149 | |
110 | |
66 | |
64 | |
56 |