Forum Discussion
Display message Matrix Level on Slicer
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
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.
1 Reply
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.