Forum Discussion
Helper IIIchange date format based on metric
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?
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 KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- parry2k
Super User
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
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 KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
