How to filter visuals based on four different dates in a single slicer in a Power Bi

(1) Share

Report

Posted on by Nisha_Innola

103

Hello All,

I have a Power Bi dashboard, where the visuals are filtered by Date 1 in Jan, Feb, Mar and by Date 1 & Date 2 in April, May, June, July and finally by Date1/Date2/Date 3/Date 4 in Aug, Sept.

I do also have a Tower column which also filters out the visuals.

I can filter out with Two dates (Date 3 & Date 4) with Calendar function with Max and Min in Aug and Sept for a single Tower. but other Tower the values are wrong as this tower is based on Date1 & Date2.

Can anyone help to filter out visuals based on four different dates in a single slicer for different months as above and based on two different towers.

Appreciate if anyone can help on this.

Categories:

General Discussion

Product Question

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

IrinaTokm 10 on at

Like (0)

Report
How to filter visuals based on four different dates in a single slicer in a Power Bi

You can do this with one slicer by using a disconnected date + an unpivoted bridge and a tiny rules table.

How

Make a disconnected SlicerDate table (for the slicer).

Unpivot Date1..Date4 into BridgeDates[FactKey, Date, Role, Tower].

Create DateRules mapping which Roles are valid per Month (and per Tower when needed).

Relationships: SlicerDate[Date] -> BridgeDates[Date], BridgeDates[FactKey] -> Fact[ID], DateRules -> BridgeDates (Month/Tower).

Wrap measures:

Value :=

CALCULATE(
[Base Measure],
TREATAS(VALUES(SlicerDate[Date]), BridgeDates[Date]),
KEEPFILTERS(BridgeDates[Role] IN VALUES(DateRules[Role]))
)

Now Jan–Mar uses Date1, Apr–Jul Date1/2, Aug–Sep Date1/2/3/4, and it respects the selected Tower.

If this helped, I’d really appreciate a like — thanks!

Was this reply helpful? Yes No