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 ...
Need Help
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 ?