Forum Discussion

sandygather's avatar
sandygather
Frequent Visitor
1 year ago
Solved

Help with Matrix visualisation

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 Dimension...
Need Help
  • v-hjannapu's avatar
    v-hjannapu
    1 year ago

    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.

v-hjannapu's avatar
v-hjannapu
Community Support
1 year ago

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.

v-hjannapu's avatar
v-hjannapu
Community Support
1 year ago

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.


  • sandygather's avatar
    sandygather
    Frequent Visitor
    1 year ago

    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

     

    • v-hjannapu's avatar
      v-hjannapu
      Community Support
      1 year ago

      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.

      • v-hjannapu's avatar
        v-hjannapu
        Community Support
        1 year ago

        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.