Don't miss your chance to take exam DP-600 or DP-700 on us!
Request nowLearn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
i everyone, i'm leaning power bi and i have been searching about how do the next:
i have a dropdown slice that is configurate by type of date
and a numeric range slice based in the same date data
i want to know if is posible to if i select for example a "last year" and the numeric range slice take the range values but doesn't lost the dates before, i mean:
take the date between 21/09/2021 and 21/09/2022
and in this case can choose dates before 21/09/2022 like 29/08/2022 or older
and change the date type to "custom" if other date is selected
i appreciate if someone can help me, i'm starting, i don't know if this is easy or hard, thanks a lot
@Greg_Deckler thanks for you help, but maybe i explained it bad,
my configuration is
i have a table (Dim_date) with dates from Ene-01-2000 and Dic-31-2030, and a table with name "Date_Range" that contains the dates by types
and the two slicer are based on Date_Range
but when i select a date, the previously date are disable
so that i want is
1) when custom is select keep the last range selected ( by type )
previous selected last 7 days
next only in the case if select custom keep the previous date, for example
2) when is selected any type take the range but don't disable the previously
in my case, the things in the line green are disable
i want
is like to assign a value to slicer, i don't know if it is possible
@LuisJ Is your type slicer coming from a disconnected table? Please confirm if I understand correctly. You want to be able to choose something in your type slicer and use that instead of the range values but you don't want the range values to change from what the user may have selected. If you choose custom, then use the values in the range slicer. Is that all correctly stated? If that is what you want, use a disconnected table for your type slicer and then something along the lines of:
Measure =
VAR __type = SELECTEDVALUE('DisconnectedTable'[Value])
VAR __Min = MIN('Dates'[Date])
VAR __Max = MAX('Dates'[Date])
RETURN
SWITCH(__type,
"custom",SUMX(FILTER('Table',[Date] >= __Min && [Date] <= __Max),[Value]),
"Last 30 Days", [Last 30 Days Measure],
"Last 7 Days", [Last 7 Days Measure],
...
)
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 55 | |
| 45 | |
| 38 | |
| 16 | |
| 14 |
| User | Count |
|---|---|
| 87 | |
| 68 | |
| 38 | |
| 29 | |
| 26 |