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 |
---|---|
65 | |
61 | |
60 | |
53 | |
27 |
User | Count |
---|---|
181 | |
83 | |
68 | |
49 | |
46 |