The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.