Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Matrix Visual Previewing Values when Collapsed from Different rows

I am working with a the matrix visual. It all pulls from one .XLSX spreadsheet. For the Rows I am using 3 hierarchical categories: Metrics, Group2, and Category (in that order). For columns I do not ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    I was able to solve my own problem with this workaround:

    Create measures for each Value:

    ProjectA Measure = 
IF(
    ISINSCOPE('Sheet Name'[Category]),
    MAX('Sheet Name'[ProjectA]),  
    BLANK()
)

    Now if the visual only contains these measures as the Values it will show as blank if collapsed or start 'deleting' the parents out without a way to add back due to not technically being in scope.

    To solve this I added an Index column, changed Visual setting: Specific Column: Index -> Set text color to white and background color to white. Then to handle the column header I copied the invisible character from this website: https://blanktext.net/

Anonymous's avatar
Anonymous
Not applicable
2 years ago

I was able to solve my own problem with this workaround:

Create measures for each Value:

ProjectA Measure = 
IF(
    ISINSCOPE('Sheet Name'[Category]),
    MAX('Sheet Name'[ProjectA]),  
    BLANK()
)

Now if the visual only contains these measures as the Values it will show as blank if collapsed or start 'deleting' the parents out without a way to add back due to not technically being in scope.

To solve this I added an Index column, changed Visual setting: Specific Column: Index -> Set text color to white and background color to white. Then to handle the column header I copied the invisible character from this website: https://blanktext.net/

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, Anonymous 

    I'm glad you solved the problem you were experiencing and shared the solution, it will help many members of the community who are experiencing similar problems to yours to be able to find a solution quickly!

     


    I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
    Best Regards,
    Fen Ling,
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.