Forum Discussion

thebigwhite's avatar
thebigwhite
Helper II
4 years ago
Solved

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 ...
Tips and Tricks
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    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.

     


     

SpartaBI's avatar
SpartaBI
Community Champion
4 years ago

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.