- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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 ?
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
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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:
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.
- Go to the model view:
- Click your field in the field list on the right.
- Open the Properties pane if it is collapsed. Then scroll down to Advanced. You're looking for a drop down called Data Category:
- Select Web URL from the list. Now the field will default to using this data type.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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:
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.
- Go to the model view:
- Click your field in the field list on the right.
- Open the Properties pane if it is collapsed. Then scroll down to Advanced. You're looking for a drop down called Data Category:
- Select Web URL from the list. Now the field will default to using this data type.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

It is not working anymore in the new version.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
11-28-2024 10:35 AM | |||
10-22-2024 06:09 AM | |||
10-17-2024 04:59 AM | |||
Anonymous
| 11-12-2024 06:26 AM | ||
11-21-2024 01:13 AM |
User | Count |
---|---|
141 | |
115 | |
84 | |
63 | |
48 |