Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
My report is connected to a online dataset, shared with my account. Therefore, I cannot add any colum, or import another table for example.
However, I need to change or create a new colum replacing dates + times by dates only. Example: 13/06/2018 16:20 must now be 13/06/2018.
Do you think this might be done with a new measure with some FORMAT or DATE function? Couldn't find the solution...
Best regards
Solved! Go to Solution.
Hi Green_Boby,
Yes, a measure can be used as value in a chart but can't be used as X-axis . To achieve your requirement, you should create a calculate column in the original PBIX file.
Calculate Column = FORMAT(Table1[DateTime2Date], "yyyy/MM/dd")
Regards,
Jimmy Tao
Hi Green_Boby,
Create a measure using DAX formula as below:
Measure = FORMAT(MAX(Table1[DateTime2Date]), "yyyy/MM/dd")
Regards,
Jimmy Tao
Hello,
Thank you for your message. I tried to use your formula, but when I cannot select STD_DATES_MODIFIED (dates only) as a X axis on a graph, when I could for STD_DATES (date+time).
Regards
Hi Green_Boby,
Yes, a measure can be used as value in a chart but can't be used as X-axis . To achieve your requirement, you should create a calculate column in the original PBIX file.
Calculate Column = FORMAT(Table1[DateTime2Date], "yyyy/MM/dd")
Regards,
Jimmy Tao
All right, I will see if I can do so in my file.
Thank you very much V-Yuta-Msft!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |