Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
thebigwhite
Helper II
Helper II

Date Format on dataset Level

Hello, 

I would like to give the possibility to the users to change the format of the columns on a report based on a Daset already prepared. 

What I have found out is that only possibile to change the format of a column by preparing a new measure on that field. 

Isn't a way for allowing users to change the date format of a dateset when they are preparing the report? 

Thanks 

 

1 ACCEPTED SOLUTION
SpartaBI
Community Champion
Community Champion

Hi @thebigwhite,
A column format string is a hardcoded property at the tabular model level.
A report builder, using a live connection, cannot change it directly.

You have a couple of options:
1. Use DirectQuery for Power BI datasets and Azure Analysis Services to connect to the dataset, instead of a live connection. This will create a local model with metadata that can be changed- So a report builder will be able to set a different format string. Note that this capability is in preview and has limitations. It also complicates your solution and has other drawbacks.

SpartaBI_1-1651140355632.png
2. Set a date format with an asterisk- Those will change the end-user display based on its regional settings.

SpartaBI_0-1651139754589.png

 


 

View solution in original post

1 REPLY 1
SpartaBI
Community Champion
Community Champion

Hi @thebigwhite,
A column format string is a hardcoded property at the tabular model level.
A report builder, using a live connection, cannot change it directly.

You have a couple of options:
1. Use DirectQuery for Power BI datasets and Azure Analysis Services to connect to the dataset, instead of a live connection. This will create a local model with metadata that can be changed- So a report builder will be able to set a different format string. Note that this capability is in preview and has limitations. It also complicates your solution and has other drawbacks.

SpartaBI_1-1651140355632.png
2. Set a date format with an asterisk- Those will change the end-user display based on its regional settings.

SpartaBI_0-1651139754589.png

 


 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors