Forum Discussion
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?
You may new a hierarchy in desktop.Add the Year,Month...columns to the hierarchy.Then click the icon to go to different levels.
Regards,
So what I gather is that this is not possible to do in PowerBI Service.
5 Replies
You may new a hierarchy in desktop.Add the Year,Month...columns to the hierarchy.Then click the icon to go to different levels.
Regards,
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??
You may also use date format.If it doesn't have the format you request,you may format it manually.
Regards,
So what I gather is that this is not possible to do in PowerBI Service.