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 August 31st. Request your voucher.
How do i pass value with special character %?
Value: Capitalizations %
I have tried 'Capitalizations %25' but it is not passing through the filter
That's not how the filter URL escaping works. You need to escape the space too.
Filter a report using query string parameters in the URL - Power BI | Microsoft Learn
That is for table and column name right?
The value 'Capitalizations %' should be passed as %27Capitalizations%20%25%27 based on the examples i have referred to but somehow my filter is not passing.
You are correct, your value should be passed as
?filter = Table_x0020_Name/Column_x0020_Name eq 'Capitalizations%20%25'
Yes that is what I applied, but unfortunately it is still not showing the filtered value.
Try with another value to confirm that you have correctly specified the table and column.
Yes, other values without % sign work well, except this one.
User | Count |
---|---|
77 | |
76 | |
36 | |
31 | |
29 |
User | Count |
---|---|
93 | |
79 | |
57 | |
48 | |
48 |