Forum Discussion
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 still shows 2016 04 not a box with 2016 then inside/above/whatever all the months.
43 Replies
Hi guys. A key requirement for this to work, is the correct sorting of your date table and data. This functionality does not work if your date data is not sorted sequentially. Once the data is sorted appropriately, then recreate the chart, starting with your date hierarchy (x-axis) then your values and finally switch 'Concatenate labels' to off. This will show the data as required.
With the newest version of Power BI, you need to drill down to the lowest level and sort by the hierarchy. Also ensure the concatenate lebels is off. Only with this sort does the hierachy not break (with my tests). Hope that helps.
I do still consider this a bug, but that is the only way I've managed to get around it.
Thank you SO MUCH!!!
this was driving me crazy. changing the sort of the visual fixed it.
Hey jfreyesmorales, anytime!! :smileyhappy: Please do mark this reply as the solution to the problem so others can also find it useful.
Thank you OneWithQuestion for pointing towards the right direction to solve the problem:
Concatenate Labels option works for the following scenario:
[1] When you first select your clustered column chart and then add your entry to the "value" and then add your fields to the "axis" and then switch your formatting "concatenate label" off
[2] without selecting a chart type, you first select the fields for the "axis" (e.g. month, quarter, year) and then select the measure for value e.g. units sold and then switch your formatting "concatenate label" off
Concatenate Labels option does not work for the following scenario:
without selecting a chart type, you first select the measure for "value" e.g. units sold and then select the fields for the "axis" (e.g. month, uarter, year) and then switch your formatting "concatenate label" off - (nothing happens)
- to me this looks like a bug
I hope that i have been clear on how to work around this problem. I have tested the above 3 appoaches a few times
I tried to follow the workaround earlier, but this basic functionality is still broken? See screenshot. I'm using the April update.
sykr0n did you do the following order:
step 1: select the stacked columns chart (do not select the fields before selecting the charts)
step 2: select the entry for the "value" field
step 3: select the multiple fields for the "Axis"
step 4: go to formatting --> x axis --> switch concatenate label to off
Does it work ok on a Bar or Column chart?
No it seems to be the same behavior.
I am using a Year and Month hierarchy connected to SSAS Live...but I wouldn't think that would make any difference???
Hן OneWithQuestion,
When you create a local hierarchy in Power BI, it works fine in area and bar charts.
I am not sure if that new feature is supported in SSAS Live, maybe someone from the support team can answere that.
I'm having this issue also. Using a clusterd column chart and a stacked column chart with and without hiarchies it doesn't concatenate or create the new non concat view. It just drills down and back up with no extra text on the descriptions.
I'm having the same issue with stacked bar and column bar charts. Neither provides the contcat label or the hiarchecal label.
Same here, hope this is fixed in next release. Option appears to have no effect in PBI Desktop.
I managed to somehow make it work, but I couldn't recreate it on a new chart with exactly the same settings.
In my case it turns out, creating a chart first (not selecting a field) and then adding measure, year, month (not a hierarchy), and setting Concatenate Labels to OFF works!
Selecting a measure first (not a blank graph) and following the steps doesn't work!
p.s. I'm using Jan '17 PBI.
Hope that helps others
Emil
Any update on getting this fixed?
Same issue. Tried all the suggested. Using April 2017 version
- 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!
