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
1 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.
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.
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.
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.
@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)
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
