Visual to display data label of another field

[DSmith4]

Hi,

I would like to make a use a visual that will display data labels with a different field than the field used in the bar chart. 

Here is my example.

I have number of items sold (sorted by item type) and total dollar amount of items sold (also sorted by item type).

I would like the bar graph visual to display a bar with the total items sold but would like the data label to show the sum dollar amount of that particular items sales.

Is there a visual to do this?

Thank you

[v-yulgu-msft]

Hi @DSmith4 ,

As a workaround, you could add "total dollar amount of items sold" field into tooltip.

Best regards,

Yuliana Gu

[hgzelaya]

hi @DSmith4  , would this be ok?

If so, you can use the grouped column and lines visual. Use the count sales value in the column field and sum Sales Value in the line field.

[DSmith4]

This will not work as I do not want to see the line.

Im only looking to see the bars. (using your screenshot) I would like to see April show a value of 507,344,810 where 110911 is currently displayed and have May show 518,484,568 for 111206 and so on..

[hgzelaya]

Do you mean the 2 values on the sambe bar? I´m not understanding

[DSmith4]

Im looking to see the data like in the last two bars except without the line.