Advanced Filtering - Filter visual less than visual slicer value

[Anonymous]

The problem:

I have this visual chart showing YTD sessions. The rest of the page is controlled by a Slicer to choose a FY_week_number, but this sessions visual should show all sessions from start of Year, LESS than chosen FY_week_number

Because I have the interaction between the FY_week_number and this visualisation to be DISABLED, I am wondering how I can control the Sessions YTD figure to be LESS THAN the selected FY_week_number from the slicer?

Hmmm?

[v-jiascu-msft]

Hi @Anonymous,

Could you please mark the proper answers as solutions?

Best Regards,

Dale

[Anonymous]

@v-jiascu-msft - If there was a proper solution, I would mark it as such. I do not feel that the question is answered at this time.

[v-jiascu-msft]

Hi @Anonymous,

Since you have disabled the interaction, the filed of the x-axis can't be from the same table with the slicer filed. So there could be two solutions.

1. If there are two tables without any relationships, it could be easy.

2. If there are two date tables with relationships, you can create a measure. Can you share a dummy sample? Then you can have a precise solution.

Best Regards,

Dale