cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Re: Concatenate Labels option does nothing?

bump... having this issue with the ribbon chart too

Re: Concatenate Labels option does nothing?

still broken even with the new desktop version...

pcloutier Frequent Visitor
Frequent Visitor

Re: Concatenate Labels option does nothing?

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.

YossiKoresh Frequent Visitor
Frequent Visitor

Re: Concatenate Labels option does nothing?

Having the same issue, it seems that "concatenate labels" option does nothing!

 

YossiKoresh Frequent Visitor
Frequent Visitor

Re: Concatenate Labels option does nothing?

Having the same issue, it seems that "concatenate labels" option does nothing!

 

Llewbear Regular Visitor
Regular Visitor

Re: Concatenate Labels option does nothing?

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. 

Re: Concatenate Labels option does nothing?

Thank you SO MUCH!!!

this was driving me crazy. changing the sort of the visual fixed it.

Llewbear Regular Visitor
Regular Visitor

Re: Concatenate Labels option does nothing?

Hey jfreyesmorales, anytime!! Smiley Happy Please do mark this reply as the solution to the problem so others can also find it useful.

anitaberg Regular Visitor
Regular Visitor

Re: Concatenate Labels option does nothing?

I managed to get this to work yesterday, then again today same issue. Unitll i remembered that the table had to be sorted by Year, Month, then the labells finally did show up with year only once then all the months above.

 

I am using year and month in the auto hierarchy.

 

But it is buggy as you don`t get the expected result by just turining off the button concatenate labels on X-axis settings.

 

 

Highlighted
tiztrain Regular Visitor
Regular Visitor

Re: Concatenate Labels option does nothing?

I was having this issue so I recreated the exact same chart on a new tab and it worked perfectly. Definitely a bug!

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 6 members 2,658 guests
Please welcome our newest community members: