This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
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:
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 3 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 9 | |
| 7 | |
| 6 | |
| 6 | |
| 5 |