Default DAX Parameter Values

[PatrickGreen]

Hi! Are there options currently to set default values for DAX parameters? 

[PatrickGreen]

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?

[v-zhouwen-msft · Accepted solution]

Hi lbendlin ,thanks for the quick reply, I'll add more.

Hi @PatrickGreen ,

If I understand correctly, when the slicer selects "Month", create a bookmark. Then insert a button and bind the button to the previous bookmark. For details, please refer to the following article

Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Learn

Best Regards,
Wenbin Zhou

[PatrickGreen]

Hi @v-zhouwen-msft ! Thanks! This could work like a filter view for me.

[lbendlin]

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?