data appear only when selected

Question

Hello&nbsp;I have dummy data:&nbsp;name &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; valueff &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;dfg &nbsp;&nbsp;ss &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ytr&nbsp;I am making graphs and matrix'es. A slicer is to control this. However I want for no data to be shown until the name has been chosen in the slicer. Is this possible?

sdjensen · Answer

You could try a measure like this - it will only return a value if name has one value in the context where the measure is shown.&nbsp;Measure = 
IF(
    HASONEVALUE( Tabel1[Name] ),
    SUM( Tabel1[Value] )
)

bibra · Answer

sdjensen&nbsp;sorry, I wrote incorrect dummy data. Instead of the value being type int, it is type String.

Forum Discussion

data appear only when selected

2 Replies

Related content

Select data from Lakehouses via Fabric API

Data Match and Selection

Fabric & Azure Data User Group Program Requirements & Benefits

Selected slicer

Selecting Multiple Columns in Data View