Power BI Web view different form Desktop View

[Anonymous]

Hi All,

I have been struggling intensely with figuring out what is happening with one of the visuals in Power BI.
I am using a simple scatter plot with only 1 filtering applied via a calculated column (which is either "Present" or "Absent"). If data is "Present" I want to show that data in the scatter plot.

In the desktop view I see 5 data points which is the correct number I should be viewing. In the web view (after publishing it) however, I only see 3 data points.

My calculated column formula is very simple too.

Formula =

VAR Max_Date=Max(Database[Date Column]

RETURN

IF ((Database[Date]=Max_Date), "Present", "Absent")

Please help me! I have my deadline very soon and I have been trying everything I can to no avail!

[Migasuke]

Hi @Anonymous ,
this might a be bit silly suggestions but it actually helped more people than I can count...
Have you checked that there is no filter applied - either from filters or from different visuals?

Please check in your Report option with reset view:

You can find it in right corner and it should put things back as you have them in your desktop.
It's a small thing but can workout.

[Anonymous]

Hi @Migasuke 

Thanks a lot for your solution. I tried to reset the filters using your method.

However, I am still getting the same result.

Any other potential solutions would be great to try as well. Thanks!

Kind regards,

[Migasuke · Accepted solution]

@Anonymous,
Frankly this sounds like a bug so I would do some testing.
How would I proceed?
1. Try to publish a copy of your report and see if the copy behaves the same way.
2. Try to re-create the scatter plot from a scratch.
3. Duplicate scatter plot and change it to different visual to see how it works with some other visual.

In case you can provide some dummy data version of your report, please send it and I can check/test on my side as well.

[Anonymous]

Hi @Migasuke 

Thanks for the suggestions. To be honest, I also think it is a bug.

I tried your suggestions:
1. Tried publishing multiple copies of report but didn't work.

2. Recreated the scatter lot again with different filtering, still wrong.

3. Tried a column chart but it gives the same result.

I think it is indeed a bug that I've encountered because I published some sample data to a workspace using the same values and filtering applied and it shows all 5 values.

Not sure what is happening but hopefully I can figure something out soon.
Thanks a lot for all your help!