Don't Show Visuals Until Selection is Made

[mjmar025]

Hi everyone,

I am building a report that allows users to scan a list of items in a table and then click that item to see more detail related to it. On the left side of the report is the table and on the right are several cards/multi-row cards that display columns & measures for a specific item that is selected on the table. My issue is that when no item is selected these cards will default to whatever sort/aggregation I have set for them. Is there any out of the box solution that would allow me to have these visuals hidden until a selection is made in the table.

I am trying to avoid creating specific measures that will default these to blank when nothing is selected. I thouught there may be a better way.

Thanks.

[lafondm]

You can use the isfiltered Function to accomplish this. I didn't want all user names to be displayed into the table until a lastname was selected. I used th efollwoing code to trap the selected data and return a list. Take a look at:

selectedLastname = 
           Var lastname = if(
              isfiltered('table'[LAST_NAME])
              ,SELECTEDVALUE('table'[LAST_NAME])
              ,Blank()
           )
RETURN
         calculate(DISTINCT(
              'table'[LAST_NAME])
              ,filter('table','table'[LAST_NAME]=lastname
               )
              )

 Now, the list will not be populated until a lastname is selected.

I know this is an older thread, but hopefully might help someone that is searching in the future. 🙂

Have FUN!

[v-danhe-msft · Accepted solution]

Hi @mjmar025 ,

You may refer to below link to show visual until selection is made:

https://community.powerbi.com/t5/Desktop/Show-blank-when-nothing-is-selected-in-the-slicers/td-p/659...

Regards,

Daniel He