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 everyone,
I work with a shared PowerBI dataset with read-only permission, therefore I cannot edit or format any fields.
My issue here is with the data fields, that are formated as Date/Time and therefore will show up with either as a hierachy (4 fields) or a full date with time included.
There is no dimensional table for the dates, all dates are fields within the fact table. I wish to present the dates as a DD/MM/YYYY format without the time stamp but I cannot format the field, and trying to create a measure formating the date or extracting the month does not work. Could there be any solutions other than ask for a format change in the source?
Thank you!
Solved! Go to Solution.
Hi @AdrianSantos___ ,
test measure like below:
Measure = FORMAT(MAX(table2[Date]),"DD/MM/YYYY")
Use account:
Dataset:
Permission(read-only):
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
Hi @AdrianSantos___ ,
test measure like below:
Measure = FORMAT(MAX(table2[Date]),"DD/MM/YYYY")
Use account:
Dataset:
Permission(read-only):
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
Hello @v-luwang-msft thank you for your reply! That's a pretty ingenious workaround for the problem.
@AdrianSantos___ , if you are using dataset, you can change column properties. You need to ask dataset owner.
The measure will not work in your case.
Check, are you allowed to change column property using column tools?
No, there is no way to format any column. Is there no way to create any measure to yield a date field?
As @arock-well mentions, a development to allow data formatting from a read-only dataset would be most helpful.
Are you aware of any future updates that will allow report developers to make custom measures in a report like @AdrianSantos___ is asking for without requiring the dataset owner make those changes to the original dataset?
To me it doesn't make sense why the whole dataset needs to be updated for something very basic like this date formatting issue, especially if it's just a one-off update that a particular report is needing.
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 |
---|---|
98 | |
98 | |
80 | |
76 | |
66 |
User | Count |
---|---|
135 | |
109 | |
104 | |
83 | |
73 |