Parameter field with filter

Question

Hi,&nbsp;i want to add a 5th parameter that is filtered by other column:&nbsp;it says:"Each tuple in table constructor must have the same number of columns" :&nbsp;&nbsp;Parameter = {&nbsp; &nbsp; ("FY", NAMEOF('00_CALENDAR'[FY]), 0),&nbsp; &nbsp; ("Quarterly", NAMEOF('00_CALENDAR'[FY &amp; Q]), 1),&nbsp; &nbsp; ("Monthly", NAMEOF('00_CALENDAR'[Month &amp; FY]), 2),&nbsp; &nbsp; ("Fortnightly", NAMEOF('00_CALENDAR'[Fortnight Date]), 3),&nbsp; &nbsp; ("MTD", NAMEOF('00_CALENDAR'[Month Date]),FILTER('00_CALENDAR','00_CALENDAR'[Current MTD]="MTD"), 4)}&nbsp;How I need to correct the line to get the "month date" column with "MTD" filtered ?&nbsp;&nbsp;Thanks !&nbsp;&nbsp;

anonymous · Accepted Answer

Hi&nbsp;cristianml&nbsp;,
Please try to create a measure firstly, and then create field parameters with fields and measure.
For more details, you can read related document:&nbsp;Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn&nbsp;,&nbsp;Field Parameters in Power BI - Microsoft Power BI Community
&nbsp;
Best regards,Community Support Team_ Binbin YuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Parameter field with filter

1 Reply

Related content

Field Parameter Question

Filter Field Parameter by Field Parameter Values without Calculated Groups

Field Parameter Hierarchy

Field parameters

Field Parameters - Individual Filters