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

Change date format in a visualization

I've got a model with about 14 different dates.

The model is published to Power BI service.

Users are now interacting with the model and adding visualizations but some want to create charts and tables using these dates, but they all want dates in a different format.

Some just want to see the month number.

Some just want to see the day.

Some just want to see the year.

Some want to see the YYYY-MM.

Some want to see the quarter.

 

How do we accomplish this in Power BI service when creating reports?

2 ACCEPTED SOLUTIONS

Accepted Solutions
Community Support Team
Community Support Team

Re: Change date format in a visualization

Hi @therealomacoder 

You may new a hierarchy in desktop.Add the Year,Month...columns to the hierarchy.Then click the icon to go to different levels.

1.png

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
therealomacoder Frequent Visitor
Frequent Visitor

Re: Change date format in a visualization

So what I gather is that this is not possible to do in PowerBI Service.

4 REPLIES 4
Community Support Team
Community Support Team

Re: Change date format in a visualization

Hi @therealomacoder 

You may new a hierarchy in desktop.Add the Year,Month...columns to the hierarchy.Then click the icon to go to different levels.

1.png

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
therealomacoder Frequent Visitor
Frequent Visitor

Re: Change date format in a visualization

So for every possible date format that the report builder may want in a report or a dashboard in PowerBI service has to first be manually created in PowerBI Desktop??

Community Support Team
Community Support Team

Re: Change date format in a visualization

Hi @therealomacoder 

You may also use date format.If it doesn't have the format you request,you may format it manually.

1.png

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
therealomacoder Frequent Visitor
Frequent Visitor

Re: Change date format in a visualization

So what I gather is that this is not possible to do in PowerBI Service.