Forum Discussion

PatrickGreen's avatar
PatrickGreen
Advocate I
1 year ago
Solved

Default DAX Parameter Values

Hi! Are there options currently to set default values for DAX parameters? 
Need Help
PatrickGreen's avatar
PatrickGreen
Advocate I
1 year ago

Hi lbendlin ! I have a parameter in DAX of this formula:

date_aggregation_parameter = {
    ("Day", NAMEOF(DateTable[Date]), 0),
    ("Week", NAMEOF(DateTable[Week]), 1),
    ("Month", NAMEOF(DateTable[Month Year]), 2),
    ("Quarter", NAMEOF(DateTable[Quarter Year]), 3),
    ("Year", NAMEOF(DateTable[Year]), 4)
}

I added it in the sheet as a slicer, where people can select the kind of "date aggregation" they want. I want to set monthly as default when a button is clicked. I am planning to do the same as well for another parameter containing text fields. Do you think this is possible?