Forum Discussion

leela77's avatar
leela77
Frequent Visitor
3 years ago
Solved

parameter date roll-up displaying weekday names

para_date_roll_up = {
    ( "Annually", NAMEOF ( 'dim_date'[financial_year] ), 0 ),
    ( "Quarterly", NAMEOF ( 'dim_date'[financial_quarter_year] ), 1 ),
    ( "Monthly", NAMEOF ( 'dim_date'[calendar_month_year] ), 2 ),
    ( "Weekly", NAMEOF ( 'dim_date'[calendar_start_of_week] ), 3 ),
    ( "Daily", FORMAT(NAMEOF ( 'dim_date'[date] ), "ddd, DD/MM/YYYY"), 4 ),
    ( "Day Of Week", NAMEOF ( 'dim_date'[week_day] ), 5 )
}

a parameter with a date roll-up (annually, quaterly, monthly, weekly, daily and day of the week) has been created. However, I want the daily, which is every day of say a certain month to show the weekday names as well without creating a calculated column. 

I have tried to format it (see in bold) but it doesn't show up in the stacked column chart visual (where the x-axis is the parameter date roll-up) when I am using the parameter date roll-up in a slicer. What am I doing wrong? 

Thank you very much in advance.  
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi leela77 ,

    Because NAMEOF() function returns the name of a column or measure, you need to create a calculated column firstly, then add this column to parameter.

    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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi leela77 ,

    Because NAMEOF() function returns the name of a column or measure, you need to create a calculated column firstly, then add this column to parameter.

    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.