How to format the dynamic xAxis created by parameter field

[CarsonLoi]

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

[Anonymous]

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]

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 ?