Display message Matrix Level on Slicer

[bilalkhokar73]

Team,

I have 3 Matrxi and both Mtarix table is connected with Single Slicer

In slicer I gave C1, C2, C3, C3

If I Select C1 in Slicer  Then My Matrix 2 and Matrix 3 used to get blank becasue Matrix 2 & 3 Contains C2 and C3 Channel data

I want the matrix which is getting blank then I want to display mesage on that , you have selected C1 you will not get data 

This message I want to Display in C2 and C3 , 

If I slected C2 & C3 in Slicer then Matrix 1 used to get blank but other Matrix giving data

Measn I want to display message in matrix on basis of slicer select data 

[v-kkf-msft · Accepted solution]

Hi @bilalkhokar73 ，

Please add the following measures to the different matrices separately.

Matrix_1 = COALESCE ( SUM ( 'Table'[Value] ), "you have selected C2/C3 you will not get data" )

Matrix_2_3 = COALESCE ( SUM ( 'Table'[Value] ), "you have selected C1 you will not get data" )

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.