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.
in power bi in filter pane when i drag agentname text field i can use contains option and start with option then i will apply filter so similarly i have to use in dax contains and start with function how i can customize dax ,my requirement is when i select partial match in match type slicer and in agentname slicer in search box i type few letters then where those letters are present in agentnames only those agentname should come on basic search value input dynamically in calculation how to implement this
You might have more success with the TextFilter visual. That allows you to match partials in a column.
Thanks Ibendlin for giving the solution, it meets my requirement partially, 2 nd requirement is whatever I search any value basis on input value in text filter ,names should visible prefix names means if I type insurance then only names should visible which starts with insurance. so how I can implement Starts with function in power bi
User | Count |
---|---|
65 | |
61 | |
60 | |
53 | |
30 |
User | Count |
---|---|
180 | |
88 | |
71 | |
48 | |
46 |