Forced Concatenation in Bar Charts [bug]?

[andrewwglenn]

In the past day or two, my report force concatenates x-axis labels when I drill down. I explicitly switched the concatenation to off, but the chart still performs in error.

Anyone else experiencing this?

[parry2k]

@andrewwglenn works for me

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

[andrewwglenn]

Thanks for the reply.

I have already done this, but when drilled, the parent label is retained and concatenated.

Seems like buggy performance.

[v-lili6-msft]

hi  @andrewwglenn 

I have tested on my side, it works well too.

could you please share your screenshots, and if possible please share your sample pbix file for us have a test.

Regards,

Lin

[andrewwglenn]

I have shown below the 3 levels of drilling granularity and the "Concatenate labels" slider to off in each image.

I simply want the label for the current level of granularity to be displayed.

Is there something I am missing?

Thank you for your help so far.

[camargos88]

Hi @andrewwglenn ,

You have to order the values in the chart in order to get the concatenate function working.

[andrewwglenn]

You mean sort the measures? Or dimensions?

I tried both in ascending and descending arrangements, and the concatenation persists.

Or do you mean something different by ordering?

[camargos88]

@andrewwglenn,

Sort it by the first item of columns in axis, if you have more than 1.

[andrewwglenn]

Thanks, Ricardo

I guess I will have to accept the limitations of the software and feature.

I appreciate it.

[camargos88]

@andrewwglenn ,

Did it work ?

I don't have idea why we need to sort it to have it working.

[andrewwglenn]

It works only when sorted by the dimension (I cannot sort by the measure and have the concatenation function as desired).

I accepted your recommendation of sorting the dimensions as a solution.