Show data when selecting an option

Hi, Syndicate_Admin 

According to your requirements description, my understanding is that you want to achieve that when you don't select the value of "Client" in the slicer of the report, you want to not display any value corresponding to the client or other values in the corresponding visual, right?

If that's the case, you can try my scheme to achieve this requirement, I made a simple example data based on your situation:

(1)You can start by creating a separate table for the "Client" field placed in a slicer and ensuring that there is no table-to-table relationship between this table and your primary table:

(2)Then you can write a measure for the corresponding value field placed in the visual like this:

Value_Slicer =

var _selectedvalue=SELECTCOLUMNS('Slicer',"1",'Slicer'[Client])

return

IF(ISFILTERED(Slicer[Client]),SUMX(FILTER('Table','Table'[Client] in _selectedvalue),'Table'[Value]),BLANK())

(3)Then you can go to the visual and replace the corresponding value field with the measure you just created, and your requirements are realized:

Best Regards,

Aniya Zhang

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