how to see a hierarchy if its not a matrix

[Avivek]

How to see a hierarchy if its not a matrix but instead a table visual.

If I need to see different hierarchiers data in the same visual but cannot use a matrix because the data to be seen in the tables are text data and not numerical data. 

Or is there any other visuals we can use to see the same.

[PaulDBrown]

@Avivek 

Apologies upfront if I'm misunderstanding the issue. You can see hierarchies in a matrix using text values:

 Can you post a depiction of the structure you wish to show?

[Avivek]

@PaulDBrown, thankyou.

If I use a matrix then the data in the rows are text and some of the data used in the values are also text which creates the problem since matrix shows 1st, last, count or count distinct of those text values. 

Is there any alternative way to see my data.

[Ashish_Mathur]

Hi,

Share some data, describe the business context and show the expected result.

[mahoneypat]

You can view text in a measure if you create a measure that turns it into a scalar result.  If there is a single text value expected, you can use MIN(Table[TextColumn} or VALUES(Table[TextColumn]).  If multiple rows of text in context, you can use CONCATENATEX(VALUES(Table[TextColumn]), Table[TextColumn], ", ").

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[Avivek]

@mahoneypat, I tried creating the coulm into a measure and it shows the following error

Is there any other way of doing this.

[mahoneypat]

Did you try the concatenatex version?  The error shows that multiple values are being returned and that function would therefore be needed to get a scalar result (i.e., single text string instead of a table of values).

Regards,

Pat

[PaulDBrown]

@Avivek 

Is there any other way of doing what exactly?

As I've shown, you can use dimensions/columns to display hierarchies in a matrix (or table) without the need of any values.
so what are you trying to show?