Annotation of bar graph with a related descriptive value

[tom_at_qunu]

I have margin of victory or defeat in a rugby game as "Margin".  I'm plotting "Sum of Margin" by Opposition in a bar chart, and would like to display the number of games contributing to that sum (more games agains old rivals, less against new opponents).  Can this be done?  I've considered overlaying with a Table but can't isolate the one value (Count of (MatchID).  Thanks.

[Anonymous · Accepted solution]

@tom_at_qunu，

I am afraid that there is no option to show the bar chart as you describe. When draging games number to Value section of bar chart, it is also easy to view the chart.

Regards,
Lydia

[Anonymous]

@tom_at_qunu,

It is difficult for us to provide you suggestions or DAX formulas based on the above description, please help to post dummy data of your table and post expected result in table format.

Regards,
Lydia

[tom_at_qunu]

Hi Lydia.. is this along the lines of what you asked?  This is my first post, so feeling my way along.  Thanks.

	Opposition	Our score	Opposition Score	Difference
Date1	Red team	15	5	10
Date2	Yellow team	0	30	-30
Date3	Red Tram	10	0	10
Date4	Green Team	20	15	5
Date5	Red Team	5	10	-5
Date6	Yellow team	10	5	5
			Sum of Difference	No. of games
		Red (10+10-5)	15	3
		Yellow (-30+5)	-25	2
		Green (5)	5	1
	I'd like to present a horizontal bar chart conparing aggregate point differential by Opponent.
	I'd like to also present a text number between the Opponent name and the bars indicating the number of games that contribute to that sum.

[Anonymous]

@tom_at_qunu,

Create the following measure in your table.

No of games = CALCULATE(COUNT(Table[Opposition]))

Create bar chart as below.


Regards,
Lydia

[tom_at_qunu]

Thanks.  I tried that along the way, but it doesn't scale well, with some of the differentials being in the hundreds, while some of the Number of games vales are ones and twos.  if you look at the paste below you'll see a space between the row headers and the bars on the graph.  I tried making a table with just Opposition and the number of games, with the intent to overlay the graph to properly locate the text number in the white space, but I can't get rid of the "Opposition" column.  is there a way to do that (keep only the column of values in the display)?  I appreciate your continued help.

[Anonymous · Accepted solution]

@tom_at_qunu，

I am afraid that there is no option to show the bar chart as you describe. When draging games number to Value section of bar chart, it is also easy to view the chart.

Regards,
Lydia

[tom_at_qunu · Accepted solution]

As there appears to be no viable workaround to attain the presentation I described, I am using Tooltips to carry the number of games as "Count of MatchID" so it will appear on mouseover.