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.

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