Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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 |
---|---|
60 | |
59 | |
56 | |
38 | |
29 |
User | Count |
---|---|
82 | |
62 | |
45 | |
40 | |
39 |