Forum Discussion

HamidBee's avatar
HamidBee
Power Participant
4 years ago

Slicer Problem

I am trying to use a slice for this data. The actual data is many columns long. As I add more fileds the bars get really narrow and these awkwrd looking numbers appear on the axis.   Below is...
Show and Tell
amitchandak's avatar
amitchandak
Super User
4 years ago

HamidBee , the second image is not clear, Add more to axis than legend and expand it using reverse square Y icon and also use concatenate label off and sort on axis

  • HamidBee's avatar
    HamidBee
    Power Participant
    4 years ago

    Thanks for your reply Amit. I'd kindly like to ask what you mean by adding more to the axis. I'll remove the legends as it may become too many. Also what do you mean by reverse square Y? Is there a place I could read to learn more about this? I'll try the concatenate label and sort it in alphabetical order.

     

    I've tried to make the image larger. I hope that this is clearer. I've been adding the same column into the axis and value. For instance I would put "column 1" into axis and "column 1" into values. Another issue that arises is I have to replicate this for like 50 columsns. Is there a way to group these and quickly just drag and drop into axis and values?

     

    Thanks ins advance.