Matrix Formatting Issue

[coatsy35]

Having some trouble formatting my Matrix. When it is fully collapsed I would like all the text to dissapear on certian columns. I have it nearly there when all but one are collapsed, howver when you collapse the last one, all the text reappears.

Nearly correct, howver when this last set is collapsed, the text comes back

Completely collased all the text reappears

Does anyone have any nifty work arounds for this? as I don't want one line of a multiline order being shown when they are collapsed.

Also my account name is not looking up, it has a relationship setup between a customer table and the advice notes table and If I put the above data into a table visualisation it looks up the correct account name, where as currently in a Matrix, it looks up the first account name in the list or the last account name, how do you get it to keep the account name with the correct account number?  

Any help greatly appreciated

[Anonymous · Accepted solution]

Hi @coatsy35 ,

Based on the description, try using following DAX formula and set the column conditional formatting.

Measure = IF(ISINSCOPE('Table'[Number]), 1, 0)

Besides, you can also raise a new idea and add the comments there to make the feature coming sooner.

Home (microsoft.com)

Best Regards,

Wisdom Wu

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

[parry2k]

@coatsy35 you can use ISINSCOPE function to find out where you are in hierarchy and then tweak the measure accordingly. Check more here Choosing Between ISFILTERED and ISINSCOPE: Power BI DAX Functions (youtube.com)

[coatsy35]

Which part are you referring to? the text display or the account names not matching up? Could you give me some context please if you are able. Not sure how I would alter what I have to accomodate it.