Forum Discussion

dantedg1's avatar
dantedg1
Frequent Visitor
8 years ago

Legend Format

Hi,   I've been trying to change the month legend format from "enero" to "Enero" in my powerbi graph, could someone help me?   Currently my date format is dd/mm/yyyy 00:00 am  
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hey dantedg1,

 

This isn't a problem with your legend, but a problem with your data. If you change your data to have the correct capitalization, then these axis labels will look how you want. You can do this easily by going to Query Editor -> Transform -> Format -> Capitalize Each Word (While you've selected the proper column).

 

 

Hope this helps,

Parker

dantedg1's avatar
dantedg1
Frequent Visitor
8 years ago

Hello Parker,

 

Problem is that my column format is on Date, applying the format change just changes it to numbers. DO you have any other suggestions?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    dantedg1

     

    Right, I see what you're saying. Sorry I don't know how you would change how Power BI represents a month in a certain language. If you wanted to transform the date field into a text of the month name, that would be:

     

    CalculatedMonth = FORMAT('Table'[Date], "MMMM")

    Then you could capitalize like I suggested in the previous comment.

     

    Hope this works or you find another solution,

    Parker