cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
therealomacoder
Helper I
Helper I

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
v-cherch-msft
Microsoft
Microsoft

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
Helper I
Helper I

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

View solution in original post

5 REPLIES 5
therealomacoder
Helper I
Helper I

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

View solution in original post

v-cherch-msft
Microsoft
Microsoft

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

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

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.

@v-cherch-msft 

 

The method you show here uses the same formatting for every visualization, correct?

 

Is there a way to use a different format for each visualization?  For example, I like the longer formats for a card (Monday, June 30, 2014), but a shorter format (6/30/2014) for a table or matrix.

 

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!