Matrix table

[Anonymous]

Hello there, i tried all the ways i found to work around with matrix table but nothing worked out ; My requirement is i want to show a matrix table with rows and values while row level is collapsed the text of the value fields should be blank or "-" as matrix table summarizes or take distinct text values of the fields present in values ,i dont want that to happen all i want is to hide or show blank when row is collapsed...i have tried using these measures 1. Show/hide =
VAR IsExpanded = NOT(ISFILTERED('YourTable'[Enquiry ID])) || NOT(ISFILTERED('YourTable'[Item ID]))
RETURN
IF(
IsExpanded,
'YourTable'[Total Price], // Display detailed value when expanded
BLANK() // Display blank or "-" when collapsed
)

2.Measure = IF (ISINSCOPE(Table[Product]),SELECTEDVALUE(Table[First Color]), BLANK()).

But nothing is working out when i put the measure all contents all dissapearing dont know why, please find the images below and hoping to find a solution....thank you so much in advance.

i want ti hide the underlined values when row is collapsed

so as it shows when being clicked "+"

[vaibhavkale570]

Hello,

It seems like you are trying to create a matrix table with conditional formatting to show blank or "-" values when the row is collapsed or expanded. However, the measures you provided might not be working as expected due to various reasons.

Here's a step-by-step guide on how you can achieve your requirement:

Step 1: Create a measure to display the values when the row is expanded and blank when it's collapsed.

Expanded Value =
IF (
NOT ( ISFILTERED ( 'YourTable'[Enquiry ID] ) ) || NOT ( ISFILTERED ( 'YourTable'[Item ID] ) ),
'YourTable'[Total Price], // Display detailed value when expanded
BLANK() // Display blank or "-" when collapsed
)

Step 2: Create another measure to handle the display of blank or "-" values when the row is collapsed.

Collapsed Value =
IF (
NOT ( ISFILTERED ( 'YourTable'[Enquiry ID] ) ) || NOT ( ISFILTERED ( 'YourTable'[Item ID] ) ),
BLANK(), // Display blank when expanded
"-" // Display "-" when collapsed
)

Step 3: Use the above measures in your matrix table.

Place the 'YourTable'[Enquiry ID] and 'YourTable'[Item ID] in the rows section of the matrix table. Then, put the 'Expanded Value' measure in the Values section, and the 'Collapsed Value' measure in the Values section as well. Now, you should have two sets of values in your matrix table, and they will appear based on whether the rows are expanded or collapsed.

When you expand a row, the 'Expanded Value' will show the actual value from the 'Total Price' column, and when you collapse a row, the 'Collapsed Value' will display a "-" character.

Please make sure to adjust the measure and column names according to your actual data model. Also, verify that your table names and columns are correctly referred to in the measures.

If you encounter any issues, double-check your data model and ensure that the relationships between the tables are correctly established. Also, verify that the data in the 'Total Price' column is present and correctly formatted for the measure to work as expected.

[foodd]

Would you please add your work-in-progress RFQ.pbix, as well as the source data file in Excel format?  This allows members of the Forum to understand the state.

[parry2k]

@Anonymous can be easily solved with ISINSCOPE, check the video on my channel 

https://youtu.be/Nd1jP9C8ZvQ

https://youtu.be/ox-X2jN5KbE

👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo