Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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?
Proud to be a Super User!
Paul on Linkedin.
@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.
Hi,
Share some data, describe the business context and show the expected result.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@mahoneypat, I tried creating the coulm into a measure and it shows the following error
Is there any other way of doing this.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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?
Proud to be a Super User!
Paul on Linkedin.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
79 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |