change date format based on metric

[EugenioProlog]

I have a table called dim__calendar with a date column called dt_date.
This column is used as X-axis on a line graph.

I want to change its format using a newly created metric on a Data Segmentation. 

For example if i choose:

Option -> Display Format
Day -> dd-mm-yyyy
Month -> mm-yyyy

Quarter -> Qq-yyyy

Year -> yyyy

Is there a way to do that?

[Anonymous · Accepted solution]

Hi @EugenioProlog ,

As Parry2k said, you can achieve this with field parameters.

For more details, you can refer to below document:

Use report readers to change visuals (preview) - Power BI | Microsoft Learn

Best Regards,
Adamk Kong

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

[parry2k]

@EugenioProlog I would recommend to create field parameter and use that on x-axis and based on the selection the x-axis column will change , and also the format related to that field.

Learn TOP 3 use cases of new FIELD parameter feature introduced in May 2022 Power BI Update