cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
v-cherch-msft Super Contributor
Super Contributor

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.

View solution in original post

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.

View solution in original post

4 REPLIES 4
v-cherch-msft Super Contributor
Super Contributor

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.

View solution in original post

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??

v-cherch-msft Super Contributor
Super Contributor

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.

View solution in original post

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Top Kudoed Authors
Users Online
Currently online: 344 members 3,497 guests
Please welcome our newest community members: