How to show the bank holidays of previous year (month and working day) in a custom tooltip?

[marcl1]

Dear gents,

In a report I show by working day our companies that are on vacation : works really fine for the current year (and month and working day) green bar and green list

How could i get the same list for previous year ? I tried switching off the "keep all filters" button on the custom tooltip page, passed the year and previous year in two separated table and synced the month, but then i'm missing the working day ?

thx in advance for any idea !

[marcl1]

I'm not convinced by your solution : need to dig in...

[v-shex-msft]

HI @marcl1,

Perhaps you can try to disable the filter effect and interaction from the current visual on the report tooltip and add a measure formula to apply a custom filter effect on the visual level filter.

Applying a measure filter in Power BI - SQLBI

Regards,

Xiaoxin Sheng