Forum Discussion

istolcman's avatar
istolcman
New Member
8 years ago

Displaying Fiscal Calendar label

Hello,

 

I'm working currently with Power BI Desktop using OLAP cubes to load data. After processing the time dimension and presenting it on the graph Power BI automatically assign "Fiscal Calendar..." label to X-axis members on it, which sometimes is simply too long (as shown below). Instead of that I want to use simply "2016" or "FY 2016". And just to add - I don't use formulation Fiscal Calendar anywhere, just Fiscal Year.

 

 

Do you know, if it's possible to adjust it?

1 Reply

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi istolcman,

     

    Are you using import mode or live connection mode?

     

    If you are using import mode, you can simply create a new date column or modify the current data column.

    if you are using live connection mode, you can not modify any columns. As a workaround, you can set concatenate on in the format pane(if hirerachy exists) or set Text size smaller to save some space in X-axis.

     

    Regards,

    Jimmy Tao