topic Re: Filter not working after publishing to workspace in DAX Commands and Tips

Filter not working after publishing to workspace

Janaki70 — Tue, 17 Oct 2023 12:37:46 GMT

Good day

I am currently facing an issue where the filter does not work when published on workspace. For example , I tried refreshing a certain page on a desktop version and the data reflects correctly, whereby the user is able to toggle between different dates. But as soon as you publish this onto the workspace the filter is diabled. This filter has always been working right up until yesterday.

Kindly assist

desktop version

published version

Re: Filter not working after publishing to workspace

DallasBaba — Tue, 17 Oct 2023 22:23:34 GMT

Janaki70can you re-publish the report from power BI desktop with a differe name ? Or Can you click the green rest button on the web service to see if this work

Let me know is this work

@ me in replies or I'll lose your thread!!!

Re: Filter not working after publishing to workspace

Janaki70 — Wed, 18 Oct 2023 08:50:19 GMT

Good day

Thank you , the renaming of the dashboard worked. This issue has affected multiple dashoards, any suggestions besides renaming them? We have more than 50 dashboards which are affected since they souce the same dataset.

Kindly advise.

Re: Filter not working after publishing to workspace

DallasBaba — Wed, 18 Oct 2023 16:28:23 GMT

Janaki70Can you add a new Date Slicer to the reports/Dashboard and re-publish to the web service? If this works, you can apply the same step to all reports if your Dashboards are based on pin visuals from different reports.

Or let's try the following:

1 - Is the Power BI Desktop version used to create the reports compatible with the Power BI Service version? An outdated desktop version might lead to compatibility issues when published.

2 - You can review the refresh schedules settings because issues can arise if the data refresh schedules are not configured correctly. Or If the refresh is disabled when a 4-time failed attempt occurred.

3 - Clear the cache on the Power BI Service. Sometimes, this can resolve issues with filters not working as expected.

4 - Another possible cause is custom visuals. Verify that the filter is not affected by any custom visuals or extensions.

5 - If none of these steps work, it's possible that you might want to re-publish all your reports/Dashboard in a new workspace or create a workspace App to avoid sharing multiple links to users for accessing the Dashboards

Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Let me know if this work
@ me in replies or I'll lose your thread!!!

Thanks

Re: Filter not working after publishing to workspace

Janaki70 — Mon, 23 Oct 2023 08:04:12 GMT

hi DallasBaba

Thank you for the above points to try. The problem was resolved by changing the date into text format and representing it on the filter. No issues after that .

Thank you for the quick response and assistance.