Cumulative Visuals not filtering the others visuals correctly

Hope everyone is doing good in these tough time.

I have came across a scenario when i click on a cumulative visuals for a particular month, others visuals should get filtered for that cumulative total, but instead of this visuals are getting filtered for the actual month total.

Here is the snapshot to explain what i have been looking. If i select september month in chart 1, i want to see the break of cumulative total break which is 84 on chart 2 and chart 3.

I have attached pbix file for quick reference.

Hope someone will be able help me on this.
Cumulative check.pbix (92.8 KB)

Hello @nbaraili,

Thank You for posting your query onto the Forum.

Well the reason why “Chart No. 2” and “Chart No. 3” are getting filtered and showing the results for only that particular month is because the values supplied in those charts are the “Active Headcount” measure i.e. values for that particular individual month rather than that replace it with the “Cumulative Headcount” measures in those two charts and visuals will show the values getting filtered out cumulatively.

Below is the results provided for the reference -

I’m also attaching the working of the PBIX file for the reference purposes as well.

Hoping you find this useful and meets your requirements that you’ve been lokking for. :slightly_smiling_face:

Thanks and Warm Regards,
Harsh

Cumulative check - Harsh.pbix (93.8 KB)

2 Likes

Hello Harsh,
Thank you very much for your help.

Regards,
Niraj

Hello @nbaraili

You’re Welcome. :slightly_smiling_face:

I’m glad that I was able to assist you.

Thanks and Warm Regards,
Harsh