Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have what i thought was a fairly simple measure to allow a visual to be filtered by selection and default to the current month if nothing is selected:
the measure works as expected if a month is selected, it even returns the correct value if nothing is selected (checked by putting it in a card) but the visual is not filtering to the defult (current) month if nothing is selected. i made the default month a variable to see if that would fix and it is still not working - I'm stuck as to what to try next?
The Measure:
IF(
DISTINCTCOUNT( DIM_Calendar[MonthYear] )=1,
the correct value,
the defult (current)value
)
i tried this and it didnt work, the card now shows blank if nothing is selected:
Selected Month =
IF (
DISTINCTCOUNT ( DIM_Calendar[MonthYear] ) = 1,
SELECTEDVALUE (
DIM_Calendar[MonthYear],
CALCULATE (
DISTINCT ( DIM_Calendar[MonthYear] ),
DIM_Calendar[CurMonthOffset] = 0
)
)
)
IS this what you want?
my measure does that the problem is when the alternate result is returned for selected value it doesnt pass to a filter. note it is returning the correct value just not filtering.
i tried to simplify the dax to make it easier to trouble shoot - the full measure is here:
If i select a month it filters correctly:
if no date is selected it shows all the data:
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
22 | |
7 | |
6 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |