Forum Discussion

Kavita_PIA's avatar
Kavita_PIA
Frequent Visitor
3 years ago
Solved

Power BI_Matrix Table and Slicer Selection

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

Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    3 years ago

    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.

3 Replies

  • speedramps's avatar
    speedramps
    Icon for Super User rankSuper User
    3 years ago

    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

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    3 years ago

    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.

  • AbbasG's avatar
    AbbasG
    Icon for Memorable Member rankMemorable Member
    3 years ago

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