Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |