- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
2. Set a date format with an asterisk- Those will change the end-user display based on its regional settings.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
2. Set a date format with an asterisk- Those will change the end-user display based on its regional settings.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-05-2024 12:28 PM | |||
06-27-2024 07:15 AM | |||
06-02-2024 04:30 AM | |||
07-09-2021 06:40 AM | |||
05-16-2024 11:33 AM |
User | Count |
---|---|
55 | |
52 | |
49 | |
13 | |
11 |