Parameter field with filter

[cristianml]

Hi,

i want to add a 5th parameter that is filtered by other column:

it says:

"Each tuple in table constructor must have the same number of columns" :

Parameter = {

    ("FY", NAMEOF('00_CALENDAR'[FY]), 0),

    ("Quarterly", NAMEOF('00_CALENDAR'[FY & Q]), 1),

    ("Monthly", NAMEOF('00_CALENDAR'[Month & FY]), 2),

    ("Fortnightly", NAMEOF('00_CALENDAR'[Fortnight Date]), 3),

    ("MTD", NAMEOF('00_CALENDAR'[Month Date]),FILTER('00_CALENDAR','00_CALENDAR'[Current MTD]="MTD"), 4)

}

How I need to correct the line to get the "month date" column with "MTD" filtered ? 

Thanks !

[Anonymous · Accepted solution]

Hi @cristianml ,

Please try to create a measure firstly, and then create field parameters with fields and measure.

For more details, you can read related document: Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn , Field Parameters in Power BI - Microsoft Power BI Community

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.