Forum Discussion

therealomacoder's avatar
therealomacoder
Helper II
7 years ago
Solved

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 tab...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    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.

    Regards,

  • therealomacoder's avatar
    therealomacoder
    7 years ago

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

therealomacoder's avatar
therealomacoder
Helper II
7 years ago

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's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi therealomacoder 

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

Regards,

  • alwweb's avatar
    alwweb
    Advocate II
    6 years ago

    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.