Forum Discussion

CarsonLoi's avatar
CarsonLoi
Regular Visitor
2 years ago

How to format the dynamic xAxis created by parameter field

I used Fields Parameter to create the dynamic xAxis representing daily / weekly / monthly interval of a bar chart.

However, I can not figure out how to change the format of the xAxis when selecting different interval (daily / weekly / monthly)

 

Current xAxis format is all shown at YYYY MMM format

 

What I would like to archieve is:

daily / weekly xAxis format:  YYYY-MM-DD

monthly xAxis format: YYYY MMM

 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi CarsonLoi ,

    I create a new table.

    DateTable = 
ADDCOLUMNS (
    CALENDAR (DATE(2024, 1, 1), DATE(2024, 2, 29)),
    "Year", YEAR([Date]),
    "Month", FORMAT([Date], "YYYY MMM"),
    "Week", FORMAT([Date], "YYYY-MM-DD"),
    "Day", FORMAT([Date], "YYYY-MM-DD")
)

    Then I create a parameter.

    DateParameter = 
{
    ("Daily", NAMEOF('DateTable'[Day]), 0),
    ("Weekly", NAMEOF('DateTable'[Week]), 1),
    ("Monthly", NAMEOF('DateTable'[Month]), 2)
}

    Then you can see what you want.

    If you want to learn more, you can read this document: Dynamically Display X and Y Axis Data in Power BI (mssqltips.com)

     

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • CarsonLoi's avatar
      CarsonLoi
      Regular Visitor
      2 years ago

      Hi mate, thanks for the reply!

      There's 1 more thing I would like to have your instruction, 

      According to the table you have created, the month format is yyyy mmm (e.g. 2024 Jan),

      the xAxis format of the monthly interval is simply mmm (e.g. Jan), which seems not aligned with the table format at yyyy mmm.

      Therefore, I wonder how the xAxis format the date and can we control / customize the format ?