Forum Discussion

OneWithQuestion's avatar
OneWithQuestion
Icon for Post Prodigy rankPost Prodigy
9 years ago

concatenate x-axis does not work for all char types?

The new feature to turn off concatenation does not work for all chart types such as the Line and Stacked Column Chart.

 

Does anyone know if that is a bug and they plan to fix that or...?

 

Thanks!

Need Help

25 Replies

  • Amanda's avatar
    Amanda
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hey Everyone,

     

    Please try resorting your axis alphabetically (even if it is that way now, sort by something different and then alphabetically again). The hierarchical axis works for combo charts just the same as column charts currently. 

     

     

     

    • Ikeumlaut's avatar
      Ikeumlaut
      Icon for Advocate I rankAdvocate I
      8 years ago

      This seems to work now for line and stacked column chart! Thank you very much!

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi!

        I'm currently having the same problem! My x axis has week numbers and year.

         

        Tried the tip that Amanda posted, but it is just working for descending order and I want my chart in ascending order. Anyone who have experienced the same and have a solution for this?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Ok, but what if I don't want the x-axis to be sorted alphabetically?  Is there a solution where I can keep concatenate labels off while also not sorting alphabetically?

       

      I sorted my x-axis alphabetically and the concatenate labels option was turned off, but when I tried to resort by a different metric (e.g. total sales), the concatenate labels option was turned back on.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      9 months to fix a single line of code? Is this some kind of joke?

      • Ernesto's avatar
        Ernesto
        Icon for Advocate I rankAdvocate I
        9 years ago

        At this point I am pretty sure the "one liner" fix wasn't a one line after all. I just wish they could have informed that it would take a year or so to fix it, so everyone could have taken a different path. 

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    9 years ago

    Hi OneWithQuestion,

     

    Based on my test in the latest Power BI desktop version 2.41.4581.361, Concatenate Fields can work fine both in a line chart and stacked column chart. Please follow the steps below to use this feature:

     

    1. Create a line chart which has hierarchy.

    2. Click the button to expand all levels.

     

    3. Concatenate Fields is turned on by default.

     

    4. Turn off this feature.

     

    Reference:
    Hierarchical axis

     

    Best Regards,
    Qiuyun Yu

    • OneWithQuestion's avatar
      OneWithQuestion
      Icon for Post Prodigy rankPost Prodigy
      9 years ago

      It does not seem to work for the combined line and stacked chart though:

       

      Neither of those seem to support it :(

      • v-qiuyu-msft's avatar
        v-qiuyu-msft
        Icon for Community Support rankCommunity Support
        9 years ago

        Hi OneWithQuestion,

         

        I also find the Concatenate Fields feature is not supported in combo chart. And I have reported this issue internally, will get you update once get information from product team.

         

        Best Regards,
        Qiuyun Yu

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi,

       

      This intially worked for the first two test 'drill into' a clustered column chart but then it start concatenating again.  I have the most recent version of Power BI Desktop (June 2017 update). 

       

      The 'turn off' concatenation option does not work.  MS BI really needs to fix this as it become worthless if you drill more than one or two levels.

       

      Regards,

      • Ernesto's avatar
        Ernesto
        Icon for Advocate I rankAdvocate I
        9 years ago

        It is really frustrating to hear that there is a simple fix in february and then wait until July to find out the fix isn't out there yet. If not going to be fixed, I rather be told so.