The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hello
I have dummy data:
name value
ff dfg
ss ytr
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?
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.
Measure = IF( HASONEVALUE( Tabel1[Name] ), SUM( Tabel1[Value] ) )
@sdjensen sorry, I wrote incorrect dummy data. Instead of the value being type int, it is type String.
User | Count |
---|---|
69 | |
69 | |
66 | |
54 | |
28 |
User | Count |
---|---|
112 | |
82 | |
66 | |
48 | |
43 |