Forum Discussion

OneWithQuestion's avatar
OneWithQuestion
Post Prodigy
9 years ago

Concatenate Labels option does nothing?

Using this option in the service, I don't get any change to take place.   I'm using the area chart.   Anyone else have this issue?   I have Year, then Month in a hierarchy... expanding out stil...
Need Help
Llewbear's avatar
Llewbear
Advocate I
9 years ago
Hi guys! I also first struggled with this, but think I've managed to figure it out. You need to follow the process below to get your labels concatenated or un-concatenated. Step 1: Create a table and add your 'Date hierarchy' and 'Measure' Step 2: Turn your table into the chart you would like, i.e. line, bar or area chart (stacked or normal) Step 3: 'Expand all down one level in the hierarchy' until you've reached your desired hierarchy level Step 4: Under the Formatting Pane, open the X-Axis settings and change the 'Type' from 'Continuous' to 'Categorical' Step 5: Switch the 'Concatenate labels' slider to off And voila, you have a perfectly working Concatenate label option. The key here is to start with a table, add your variables, drill down, change to categorical and then only it works perfectly. Hope this helps. Have an awesome day!! Llewellyn Holtshausen Databear.com - Your Data, our Story
  • Ernesto's avatar
    Ernesto
    Advocate I
    9 years ago

    I might be going crazy here, but the options just dissapeared from some chart types in powerbi desktops latest update?

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Still not working properly. My hierarchy has 7 levels and concatenation of drill-down labels makes the chart completely unusable.

      • lbuckle's avatar
        lbuckle
        Frequent Visitor
        8 years ago

        I have tried this so many times and followed all the different sets of instructions in this thread but I just can't make it work with my data. I'm using a date table and I've tried with the date field, plus separate year and month fields. I've tried with different charts. I've tried everything suggested and I just can't get this to work. Essentially my visuals are meaningless if I can't format the date legend properly. Which means hours of wasted time trying to knit everything together. I'm using September 2017 version. I'd request an update if I thought this had been fixed. So frustrating. :smileysad: