The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All,
I am new to Power BI and trying to work out if we can create something similar to Screenshot 1 in Power BI. Please note that Values here are actually Measures and remaining are all Dimensions. I can show the Measures in Row but as soon I add dimensions, it shows up like in Screenshot 2
Screenshot 1
Screenshot 2
Solved! Go to Solution.
Hi @sandygather,
You want to show Network Type under Measure Type in the rows, just like in Screenshot 1 you shared earlier.
If you change column to rows then you will get the excepted output.I tested it with my sample data, and it worked fine. Please find the attached screenshot and Pbix for your reference.
Hope the above provided information help you resolve the issue, if you have any further concerns or queries, please feel free to reach out to us.
Regards,
Harshitha.
Hi @sandygather,
Thank you for reaching out to the Microsoft fabric community forum.
The matrix is not showing the dimensions the way you want. To fix it, try adding NetworkType first and then SpeedTier under Columns, and put MeasureType in Rows. Also, go to the matrix format settings and turn off the stepped layout .that should give you the layout like your Screenshot 1.
I tested it with my sample data, and it worked fine. Please find the attached Pbix for your reference.
Hope the above provided information help you resolve the issue, if you have any further concerns or queries, please feel free to reach out to us.
Regards,
Harshitha.
Hi @sandygather,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.
Regards,
Harshitha.
Hi @v-hjannapu ,
Thanks for your response.
I had a look at your recommendation but it does not appear to fulfill my requirement. Below is what I got from your pbix file. However, my requirement is to show Netwrok Type under Measure Type in the rows. Please refer to my original post Screenshot 1
Hi @sandygather,
You want to show Network Type under Measure Type in the rows, just like in Screenshot 1 you shared earlier.
If you change column to rows then you will get the excepted output.I tested it with my sample data, and it worked fine. Please find the attached screenshot and Pbix for your reference.
Hope the above provided information help you resolve the issue, if you have any further concerns or queries, please feel free to reach out to us.
Regards,
Harshitha.
Hi @sandygather,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.
Regards,
Harshitha.
Hi @sandygather,
I wanted to follow up and see if you have had a chance to review the information that was shared. If you have any additional questions or need further clarification, please don’t hesitate to reach out. I am here to assist with any concerns you might have.
Regards,
Harshitha.
User | Count |
---|---|
5 | |
2 | |
2 | |
2 | |
2 |
User | Count |
---|---|
11 | |
7 | |
5 | |
4 | |
4 |