Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi, guys, I need to create an auxiliary dcalendar to use in a line graph only the date from the range of the date selected by the user.
In the case of the chart above, I would like to show the data from 12/31/2019, the last day of the year before the selected date, until 01/06/2020, which is the selected date. When I try to create a range using datesbetwenn it doesn't understand the range. Is it possible to do this with dax?
@STEPH0018 So, you would want your calendar table disconnected from your slicer and then you could do this:
Measure =
VAR __MaxDate = SELECTEDVALUE('Slicer'[Date])
VAR __MinDate = DATE(YEAR(__MaxDate)-1,12,31)
VAR __CurrentDate = MAX('DateAxisTable'[Date])
RETURN
IF(__CurrentDate >= __MinDate && __CurrentDate <= __MaxDate,[your measure to display],BLANK())
The idea would be how to put the two dates here automatically:
I, Greg, so I would like to make the change only to the graph, not the measure. A filter in the visual to show just before the user-selected date until the last day of the previous year, measurement values do not change. But quaht would be the 'Slicer'[Date]?
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 9 | |
| 7 | |
| 6 | |
| 6 | |
| 5 |
| User | Count |
|---|---|
| 24 | |
| 21 | |
| 17 | |
| 14 | |
| 13 |