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.
Hi,
I'm starting to use datamarts with live conection to sql ddbb, and dataset report conection.
I can't figure out how to format dates. I set on power query date or datetime formats, close it and load it. Then I go into Column tools within the datamart formating area and choose the date field,
The field is not recognize as a date and thus it doesn't show the formating date options (neither standard nor personalize).
Does someone expierence the same issue?
Regards
Solved! Go to Solution.
I figure out how.
in the relationship tab, slect the atribute you want to fromat, and on the left side will appear the formating panel.
THanks!
Hi @Anonymous ,
In live connection "data type","data formate" all options are disabled.
The best way is to ask the dataset developer to address that in the original dataset.And you could try create a measure with Format().
Measure = FORMAT(SUM('Table'[values]),"General Number")
refer:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Lucien
I figure out how.
in the relationship tab, slect the atribute you want to fromat, and on the left side will appear the formating panel.
THanks!
This works, but when i connect datamart to Desktop version, its not showing the field with a date hierarchy, Any update on that?
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.