Skip to main content

Hi all,

 

I wish to label a certain category of data in a stacked bar chart. Using the superstore data example below I want to just label the Technology category with the sames amount.

 

I am aware that I can label the Technology category by choosing selected labels within the Labels mark but the problem is that my data is daily so I'd prefer not to avoid having to select each new Technology data point each morning.

 

Is there a way that I could label just the Technology category and leave the other two unlabeled?

 

Thanks

 

Labeling certain categories in a stacked bar chart

4 个回答
  1. 2020年3月27日 09:08

    Hi John,

     

       Sure ! The easiest way is creating a calculated field called "Label 1 only" with the following code

     

    Sum ( If [Category] = "Technology" Then [Sales] END )

     

    You need to place this in the Label Shelf.

     

    What this does is only show the Label values if the above condition is met . Hope this answers your

    problem and was helpful. Best Wishes  and Toodeloo !

     

    Sincerely,

     

    Soumitra
0/9000