Hierarchy repeated text

[Sunil0711]

Hi Team,

I have used two fields (one is brands text and other is wave) in the axis and while clicking on "Expand all down one level hierarchy" button then i got repeated text in visual. is there any options to merge the brand @ links to members, content text and show only once instead of multi. I am refering clusterd bar chart. See below for your reference. Thanks in Advance.

Current scenario:

PCI W7

PCI W8

PCI W9

need to change 

      W7 

PCI W8

      W9

[v-easonf-msft]

Hi,  @Sunil0711 

Currently 'concatenate labels'  option  is not available in clustered bar chart.

As mentioned by @AllisonKennedy ，you need to change it to clustered column chart.
I made a sample for reference.(notice to sort by the fields in axis)

You can also vote for this related ideas.

https://ideas.powerbi.com/ideas/idea/?ideaid=d5a16557-407a-4533-8fd1-9d32e1885a3a 

Best Regards,
Community Support Team _ Eason

[AllisonKennedy]

@Sunil0711  Can you change to clustered column chart instead? Option is available there, it does not matter what hierarchy you use, as long as you have more than 1 field in Axis.

[Sunil0711]

Thanks for the replies. I am using clusterd bar chart and concatenate option may be avaiable on year/date/month hierarchy. This option is not found in format . Please suggest other options.

[AllisonKennedy]

If you are using clustered bar chart, turn concatenate text labels to 'off'. https://youtu.be/pUoW2gAK0Xo 

[amitchandak]

@Sunil0711 , I case you are using matrix visual, You can use change stepped layout 

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual#stepped-layout-with-matrix-v...

in case of other visual, switch off concatenate labels