Forum Discussion
Column based on parent and daughter
Hi EriSte ,
You may try using the matrix visual.
There's a feature called drill down you can use.
Drill down and drill up in a visual - Power BI | Microsoft Docs
Drill Down and Up in Power BI Explained - RADACAD
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi EriSte ,
You may try using the matrix visual.
There's a feature called drill down you can use.
Drill down and drill up in a visual - Power BI | Microsoft Docs
Drill Down and Up in Power BI Explained - RADACAD
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for the response.
For some reason, the "Parent" and "Daughter" compete. So even though both are selected in the "Columns" field, only the one "on top" will show.
If I however have 2 matrixes with the following:
Matrix 1
Row: Week
Column: Parent
Values: Value
Matrix 2
Row: Week
Column: Daughter
Values: Value
Then when I select the parent I want in "Matrix 1", then the "Matrix 2" shows the values per daughter.
It will not work having both in the column area.
Any idea what I'm doing wrong?