Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Relative Filter Help Please

Hi All,   I am trying to work out how, when i select a month filter (from a calendar table) to apply a filter (>90 days from the selected month) to a card.   So the >90 days always references the...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Tom and thank you for replying.

 

Let me attempted to explain in more detail-

 

When I select a month from the left side radio buttons, I require (for example) the top right card to only show data that is >90 days from the month selected. 

 

The visual filter I have displayed works when there is only one month of data, but now that I have two months it does not work as the visual filter (CORP_LASTLOGONTIME) is fixed...

 

Regards,

Peter

 

 
 
 

TomMartens's avatar
TomMartens
Super User
5 years ago

Hey Anonymous ,

 

it's still not clear, what you want to achieve.

 

Please describe what has to happen when you select August 2020 from the leftmost slicer, what days have have to used to filter the measure(s) that you want to display on the card visuals.

 

It's also not clear what you mean by the "visual level filter is fixed".

Can you remove the visual level filter, and "just" rely on measure(s) that honor the month selection from the single-select slicer?

 

Regards,

Tom