Bug: Filters are not working properly

[M-IMS]

I have a table visual, All dates are dates (not date time).

User changes filter on UTM Source, lets call them utm1 and utm2, user sets utm1 and utm2, it shows value

she then removes utm2 and adds it again, and the value is different

this doesn't make sense, I can't reproduce at my end on the service.

I'm on UTC Local, User at Eastern NA

it doesn't make sense that it would happen, service is UTC, the columns are dates only, I told them to use last calendar month instead, but it doesn't make sense.

the measure are just calculate sum + userelationship

I have a video of it in real time happening

also where are you supposed to report bugs as a non enterprise peasant?

[v-nmadadi-msft]

Hi @M-IMS ,

We are following up once again regarding your query. Could you please confirm if the issue has been resolved through the support ticket with Microsoft?

If the issue has been resolved, we kindly request you to share the resolution or key insights here to help others in the community. If we don’t hear back, we’ll go ahead and close this thread.

Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

Thank you for your understanding and participation

[M-IMS · Accepted solution]

it haven't been resolved, they need the cache files from browser which isn't reproducable for now.

[v-nmadadi-msft]

Hi @M-IMS ,
Thank you for getting back with the update regarding your issue.
We’re sorry to hear that your issue hasn’t been fully resolved. We encourage you to continue engaging with the Fabric Community Forum for further support. As we’ll be closing this thread for now, please feel free to start a new one if you have any additional questions or topics you'd like to explore.
Thank you for understandinig.

[lbendlin]

All dates are dates (not date time)

They may be formatted as Date but under the covers it's always DateTime.

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

[M-IMS]

I know this might be suprising to you, but I know what I'm talking about, they're date.

and regardless of dates, why removing and readding one exact filter (text) affect this?

I tried the support yesterday, it asked about contract id, I'll use fabric trail for this i guess.

[lbendlin]

Date is just a format. The column type in Power BI / Vertipaq is always datetime.

[M-IMS]

Okay, I'm a stupid liar and they're all datetime, sure.

can you, in plain english, explain to me how that value is being affected when removing and reapplying the same exact utm filter without touching the date time columns? and why it would it only happen at one person, not at my end of the service?

I understand being skeptical to "omg i found a bug" posts, doesn't mean you turn off your brain and auto assume that it is always a PEBCAK.

[lbendlin]

You can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues

[M-IMS]

Yeah I did before I posted here Bug: Filters are not working properly - Microsoft Fabric Community

I ended up just activating fabric trial and message them this morning, got connected to one of M$ external vendors, sent him the videos, showed him everything, but doubt anything will come out of this since it isn't reproducable even by me, and even for the user who found this issue, it isn't consistent.

just leaving this up maybe someone faced something like this since I'm curious given that it makes no sense.

thanks for your time, and please don't assume everyone is a beginner just because they posted on the forum.

[v-nmadadi-msft]

Hi  @M-IMS,
Thanks for reaching out to the Microsoft fabric community forum.

We appreciate you taking the time to share your experience and efforts in troubleshooting this issue. We understand that your problem is difficult to reproduce. Since you've already reached out to the support team and provided them with all the necessary details, please rest assured that they will investigate further. Kindly allow them some time to get back to you with their findings.

In the meantime, leaving this post up is a great idea, someone in the community might have encountered a similar issue and could offer additional insights. Thank you for your patience and for contributing to the discussion

Feel free to reach out if you need further assistance. Please continue using Microsoft fabric Community for your further assistance.
Thanks and Regards