Forum Discussion

Christian's avatar
Christian
New Member
10 years ago
Solved

X-Axis Sort by month AND year

Hello.   I just started using Power BI and I am trying to discover the functions. Now my problem is that I cannot group or arrange my date the way like I had in my Excel worksheet. My data table h...
Need Help
  • asocorro's avatar
    asocorro
    10 years ago

    In Power BI it's not possible to have a hierarchy like that in the X axis.  To simulate it, you will need to create a calculated column that gives values such as, for example, 2015-Jan, 2015-Feb, etc., and then set its Sort By Column property to the column with your actual dates.

     

     

  • ashishrj's avatar
    ashishrj
    10 years ago

    Christian By creating few calculated columns you can achieve something like as shown below. Also you can format the way you want to display year-month. For instance now its 2015-07. You can also use something like July 2015 or 2015 July or 07/2015..etc. But I haven't found the grouping one you mentioned above. Hope this helps!

noshali's avatar
noshali
New Member
10 years ago

Hi

My fiscal year is July-June. I have sales data in excel sorted with date and the graphs in excel look fine as I want to show sales data from July-June. Now when I import the data in PBI. the visualization (graph) is from Jan-Dec.

Please help on how to fix this.

Thanks

  • hohlick's avatar
    hohlick
    Continued Contributor
    10 years ago

    Hi noshali

    It is better if you open your own thread to get the answer.

     

    but anyway, you can add custom column to indicate, for example, July as first month, etc., then conactenate your fiscal year with this month number to one, for example "2014-15/01", "2014-15/02" etc.

    Or, try to use "StartOfMonth" as axis