The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello All. I have a parent/child relationship I am to display in a matrix. Is there a way to make it so 'This is the title from the parent' just appears once instead of for each child record?
Thank you in advance
REQID | This is the title from the parent | ||
55 | 22 | This is the title from the parent | |
34 | This is the title from the parent |
Solved! Go to Solution.
Hi @die_kruzen
Yes, you can manipulate what to show by hierarchy level, using the ISINSCOPE function:
for example :
pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
@Ritaf1983 @amitchandak - thank you both for the info!! I wasn't aware of the ISINSCOPE....until now.
Happy to help😊
Hi @die_kruzen
Yes, you can manipulate what to show by hierarchy level, using the ISINSCOPE function:
for example :
pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
@die_kruzen , Assume the name of the parent column is parent and child is child , then have a measure like
New measure=
Switch(True(),
isinscope(Table[Child]) , blank(),
isinscope(Table[Parent]) , Max(Table[Text]) ,
Max(Table[Text])
)