Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello,
I have a report which is connected to a model, in this particular report I have used Order date's column in one of the visual. The order date is in the format-mm/dd/yy. The user now wants to change the format to mm/dd/yyyy but the changes should be done in the report and not in the model.
In the report the format options for the columns are blocked, is there any other of achieving the same without touching the query editor.
(PS-I even tried the measure for format date but it did not work woth order date)
Solved! Go to Solution.
Hi @Avivek ,
Unfortunately, this is the only solution you could suggest. When we connect live to data model, we do not have the ability to makes changes to the model .
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi @Avivek ,
Unfortunately, this is the only solution you could suggest. When we connect live to data model, we do not have the ability to makes changes to the model .
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi @Avivek ,
>>In the report the format options for the columns are blocked,
Are you using live connection model in your pbix? If so, you can only change the date format in data source.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
@v-deddai1-msft thats the solution I could suggest. But the user would like to do it without touching the model. Nothing else seemed to work for me.
You can use Format option in Report View and Change the it to mm/dd/yyyy
Proud to be a Super User!
@VijayP , this is actually a report which is connected to a data model, but in the report this option seems to be blocked. However it is there in model
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |