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.
Hi everyone, I am fairly new to PowerBI but I have been enjoying my learning experience so far. I have been stuck on a problem though and was hoping someone might have any ideas.
I have an Excel with 4 columns (this is all test data):
I have the data displayed in a matrix visual that has the ability to collapse the Categories into their respective Sub-Categories. I am trying to figure out how to have just one "Description" column that:
I was hoping that there would be an "isCollapsed" type condition I could use but I could not find a solution to this.
Thanks so much in advance to any help.
Solved! Go to Solution.
Hi @Anonymous ,
Please create a measure like below and put it into "Values" of Matrix.
Measure =
IF (
HASONEVALUE ( 'Table'[Sub-Category] ),
MAX ( 'Table'[Sub-Description] ),
IF ( HASONEVALUE ( 'Table'[Category] ), MAX ( 'Table'[Description] ), "NULL" )
)
Hi @Anonymous ,
Please create a measure like below and put it into "Values" of Matrix.
Measure =
IF (
HASONEVALUE ( 'Table'[Sub-Category] ),
MAX ( 'Table'[Sub-Description] ),
IF ( HASONEVALUE ( 'Table'[Category] ), MAX ( 'Table'[Description] ), "NULL" )
)
Thanks so much! This is exactly what I was trying to figure out.
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 |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |