Slicer Problem

[HamidBee]

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 how the actual one kind of looks like so far. I still have more fields to add.

 Below is the example.

 

Below is the table of the example.

Any help would be greatly appreciated.

  

 

[v-luwang-msft]

HI @HamidBee ，

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[v-luwang-msft]

Hi @HamidBee ，

Is it possible to configure the visual effect in the following way：

Output result:

Best Regards

Lucien

[HamidBee]

 

[rsbin]

@HamidBee,

Try this.  It appears your x-axis might be set to Continuous.  Try changing it to Categorical.

Hope that fixes one issue...your visual should be easier to work with.

[HamidBee]

Hi, 

I've put it onto categorical but it didnt change anything unfortuantely. It did however solve the issue when I removed the x axis altogether. This is the result so far but the bar charts are so tightly bound together and their is so much white space. Any ideas on how I could eliminate thiese?

 

Any help would be greatly appreciated.

Thank you

 

[amitchandak]

@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]

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.