Reply
newbiekp
Frequent Visitor
Partially syndicated - Outbound

Matrix visual flatten the rows

Hi ,

I am using Matrix visual to show my report.If I add the required columns from Source table , they go in a heirarchy forming a tree structure. I want to flatten this as show as a single line. Is it  possible ?

 

newbiekp_0-1634067417916.png

 

Secondly is there a way to make a row value of type Weburl . I can see that option in Table but not in Matrix visual.

 

Thanks

1 ACCEPTED SOLUTION
avatar user
Anonymous
Not applicable

Syndicated - Outbound

Try turning off Stepped layout in the format tab of your visualization pane under Row headers and see if it's the behavior you are looking for:

 

KeithSayer_0-1634067987537.png

For your second question: This is a bit hidden, but you can apply this to the field itself so it's allows treated as a web URL.

  1. Go to the model view:
    KeithSayer_1-1634068144388.png

     

  2. Click your field in the field list on the right.
  3. Open the Properties pane if it is collapsed. Then scroll down to Advanced. You're looking for a drop down called Data Category:
    KeithSayer_2-1634068232703.png

     

  4. Select Web URL from the list. Now the field will default to using this data type.

 

View solution in original post

3 REPLIES 3
PaulDBrown
Community Champion
Community Champion

Syndicated - Outbound

Use a table visual instead of the matrix  visual





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






avatar user
Anonymous
Not applicable

Syndicated - Outbound

Try turning off Stepped layout in the format tab of your visualization pane under Row headers and see if it's the behavior you are looking for:

 

KeithSayer_0-1634067987537.png

For your second question: This is a bit hidden, but you can apply this to the field itself so it's allows treated as a web URL.

  1. Go to the model view:
    KeithSayer_1-1634068144388.png

     

  2. Click your field in the field list on the right.
  3. Open the Properties pane if it is collapsed. Then scroll down to Advanced. You're looking for a drop down called Data Category:
    KeithSayer_2-1634068232703.png

     

  4. Select Web URL from the list. Now the field will default to using this data type.

 

Syndicated - Outbound

It is not working anymore in the new version.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)