Power BI_Matrix Table and Slicer Selection

[Kavita_PIA]

Hi

I have question regarding Matrix table, When i am selecting a slicer i am seeing only selected data , however my requirement is when i am selecting a slicer i want to show records of all fileds, if there is no data then it show me blank.

is it possible in Power Bi Desktop?

Thanks

Kavita

[v-henryk-mstf · Accepted solution]

Hi @Kavita_PIA ,

According to your description, do you want to filter specific file names by slicer and then display the corresponding data according to the file name, or show empty if there is no data.
Refer to the following.

slicer_docuemnt =
VAR sel =
    SELECTEDVALUE ( 'Table'[DocumentName] )
VAR val =
    CALCULATE ( MAX ( 'Table'[Data] ), sel = 'Table'[DocumentName] )
RETURN
    IF ( val = BLANK (), 0, val )

If the problem is still not resolved, please provide screenshots of the expected results and test data so that I can answer your questions as soon as possible

Best Regards,
Henry

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

[speedramps]

We want to help you but your description is too vaugue. Please write it again clearly.

Provide example input data as table text (not a screen print) so we can import the data to build a solution for you.
Also provide the example desired output, with a clear description of the process flow.

Remember not to share private data ... we don't want you to get into trouble. 😧

Take care to use the same table and field names in the input, output and description so we can understand your problem and help you.

You will get a quick response if you put time and effort into writing clear problem descriptions.

Vaugue descriptions can waste your time and ourtime.

Look foward to helping you when the above information is forthcoming

[AbbasG]

@Kavita_PIA can you share sample data with little bit more information on your desired output?