Forum Discussion
Hierarchy repeated text
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
5 Replies
- AllisonKennedy
Community Champion
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.
- amitchandak
Super User
Sunil0711 , I case you are using matrix visual, You can use change stepped layout
in case of other visual, switch off concatenate labels
- AllisonKennedy
If you are using clustered bar chart, turn concatenate text labels to 'off'. https://youtu.be/pUoW2gAK0Xo
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.
- v-easonf-msft
Community Support
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
