Visual level filter changes reported data in line and clustered column chart

[guusangeren]

Hi,

I'm trying to restrict the data shown on X-axis by only viewing the range which contains values above 15. This works, however, the reported values are subtracted by 15. Provided screenshots should speak for themselves. Is this a bug, or some logic I don't understand?

[v-danhe-msft]

Hi @guusangeren,

Based on my test, it could work on my side:

Could you please share me the pbix if possible?

Regards,

Daniel He

[guusangeren]

Ah sorry, no can do because it's cube-data, MSOLAP.5 . I forgot to mention that but now that I see your example showing the correct numbers, I realize that might be important.

After seeing your table I reckoned it might be helpful to show my own as well, and found another strange event occurring: The grand total does not decrease with 15, but only with 11 when enabling the filter. This got me thinking, maybe there is something going on with the unique (non-cumulated) values on which powerbi bases the total. A little background on the dataset: it's a count of preregistrations for an event, on which the bars in my previous post show the registrations per day, and the line shows the cumulated count of all registrations to date.

Although the CumulatiefAantalGeregistreerdOpleiding is calculated  (and I realize this might be related), i.m.o. a 'visual filter' should never alter data, just show different parts of it to emphasize on what is important. When I don't use that filter, the trail on the left becomes very long as there is a long period where almost nothing happens, as first registrations are most of the time about 5/6 months before the event. This automatically makes the important bits too small. I am currently using an excel template (which is a bit more versatile and lenient in visualisation ways) to acquire the data and distribute the results via email, but I want to take advantage of our company's enterprise powerbi license and give everybody continous access to the reports (and indeed, save some time for myself as well).

[v-danhe-msft]

Hi @guusangeren,

I have changed my data with a measure to show the picture you have posted, but I could still get the correct result:

I think the problem may due to your measure, could you please share your datat structure and formula of your measure if possible?

Regards,

Daniel He

[guusangeren]

Hi Daniel,

thanks for your support. I think we're at an impasse here, as I don't have access to the underlying data and formulas of measures. I have notified our BI-department (as I'm in marketing intelligence, I use what's provided by them), and will keep you updated as to whether we find a solution or at least the root of the problem.