cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Raptor Frequent Visitor
Frequent Visitor

Shared dataset: Format existing measure

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Shared dataset: Format existing measure

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.

 

16.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Community Support Team
Community Support Team

Re: Shared dataset: Format existing measure

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.

 

16.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Community Support Team
Community Support Team

Re: Shared dataset: Format existing measure

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

Raptor Frequent Visitor
Frequent Visitor

Re: Shared dataset: Format existing measure

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.

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)