Forum Discussion

finley0726's avatar
finley0726
Frequent Visitor
2 years ago
Solved

matrix drill down issue

I have a matrix with Unit Name and then when you expand you see all the Unit Types under the Unit Name. I have 3 variables that all vary by Unit Type (var1,var2,var3). all is well.

 

 

the issue is when I add a value to the matrix that does NOT vary by Unit Type. It screws up the Unit Type/Unit Name relationship completely and displays ALL unit types for all unit names for every single unit name. 

 

I'm guessing this is a relationship issue but I'm not sure what to do. The new variable has no way of connecting to unit type and ideally I just want it to duplicate for all unit types under that unit name

 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi finley0726 ,

    This could be a relationship issue, as you mentioned. You can try troubleshooting the relationship between Unit Name and Unit Type.

    Relationship troubleshooting guidance - Power BI | Microsoft Learn

     

     

    How to Get Your Question Answered Quickly 

     

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

     

    Best Regards
    Community Support Team _ Rongtie

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.