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 MS Power BI gurus,
since I am quite new to the topic of MS Power BI (former user of Oracle BI EE), I was wondering, if it is possible to change the format of a measure / attribute / KPI within a shared dataset within Power BI Desktop?
Example
Current state of "Date": DD.MM.YYYY
Change it to: DD-MM-YYYY
Usually, I would do all the formating within the "data layer" when creating a new report from scratch but when using a published dataset I am not able to see this section.
Maybe someone could share some information.
Best regards and thanks in advance
Carsten
Solved! Go to Solution.
Hi @Raptor ,
You can download the pbix file from the report page in Power BI Service, open the downloaded pbix in Power BI Desktop , then format the date measure like DAX formula date = FORMAT(Table1[Date],"DD-MM-YYYY"), and then republish again.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Raptor ,
Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.
Best regards
Amy
It is somehow a solution but did not really anwser my question, since I did not want to use the report (from Poweer BI service) itself but a dataset which is gained using MS Power BI Desktop.
Anyway, thanks for your help.
Hi @Raptor ,
You can download the pbix file from the report page in Power BI Service, open the downloaded pbix in Power BI Desktop , then format the date measure like DAX formula date = FORMAT(Table1[Date],"DD-MM-YYYY"), and then republish again.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |