Forum Discussion

KarenFingerhut's avatar
KarenFingerhut
Responsive Resident
3 years ago

Published Version Vs Desktop Version Filter Not Working as it should

Hi there   I hope someone can help me   I published a report which has a drill through from a summary page to a backdata tab which shows the granular data. There is a filter preset to a certain c...
Need Help
v-yinliw-msft's avatar
v-yinliw-msft
Community Support
3 years ago

Hi KarenFingerhut,

 

It depends on what the filter it is. There are some reasons about the problem.

1.The Desktop and The Service may use the different date, it means they handle the parsing of date differently, it may cause the filter, the measure or the column mistake.

2.When the pbix file is published, the same filters translate to a different way, like -1/0 & True/False.

3.You can try to pin the visual to the dashboard.

 

Hope this helps you, if you can provide more details, please tell me and then find out the solutions.

 

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

KarenFingerhut's avatar
KarenFingerhut
Responsive Resident
3 years ago

Hi there

Thanks so much for replying 🙂

 

The first screenshot below is the slicer available to the users

With nothing selected the following records look like this, which is correct

 

 

However when I slice (see above) on the word 'Call' the table then shows incorrect information, see below. In fact its happening on others too. The figures completly change. 

 

I'm completely baffled by it 😞

 

Any help would be really appreciated

 

Many thanks

Karen