Switch a row filter

[RobbeVL]

Hi All,

I'm having trouble rapping my head around a calculation that shouldn't be too hard.

I have following visuals

The first one is a visuals that shows me an overview of how many people are available.
The second one shows me a list of all people that are available.

So standard, the list shows ALL consultants, available or not available. (also the ones not showing in that waterfall viz).

Required result:
I would like to see the names list filtered on "Today" even when today is not filtered in the overview viz.
When "in 2 weeks" is selected, I only want the consultants available in 2 weeks to show up.
(Today, in 2 weeks,... are in the same table as the consultant name, 1 status per consultant)

Main question, how can I set it standard to "Today" filter?

Any help?

[v-yuta-msft]

@RobbeVL ,

You can create a calculate column to flag today's data:

Flag =
IF ( Table[Date] = TODAY (), 1, 0 )

Then drag the Flag column to the visual pane and select '1':

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[RobbeVL]

Hi @v-yuta-msft ,

Thanks for the reply.

But is not really what I'm looking for.

As you can see in the visual, "Today" is already in a column. (it doesnt actually mean today).
The challenge is the filtering.

Basically, my names list needs to be standard filtered on that column "today". But when the viz I showed is filtered on "in 2 weeks", "today" filter should be replaced by "in 2 weeks".

I hope this is more clear.

Robbe

[tex628 · Accepted solution]

You should be able to use this measure:

Measure 2 = IF(CALCULATE(ISFILTERED('Table (2)'[Status]),ALLSELECTED('Table (2)')),SELECTEDVALUE('Table (2)'[Status]),IF(SELECTEDVALUE('Table (2)'[Status])="Today", "Today" , BLANK()))

But since its a measure it needs to be in the table to be evaluated properly, but you can just hide the column in your table. 
Nothing selectedIn 2 Weeks selected

[RobbeVL]

Anyone?
Need more details?