Hi Andreas. Here is what I was able to do:

To put summary numbers behind the chart, you would need to hack a solution using a dual axis. (You would create a second chart, and layer it behind the first.)

The trick is getting the positioning consistent, and placing a zero if needed.

You might use use a second data source that just contains coordinates for the four quadrants, and blend that with the project totals.

Sorry - I missed the second part of your question, which was how would you get each of those numbers in the background of the proper quadrant. Other than what Branden Kornell suggested above, I can't think of a way to get the quadrant totals placed appropriately. My first instinct was to create a separate worksheet filtered to each quadrant value (i.e. High Risk / High Volume, High Risk / Low Volume, etc), display the total in a circle, and place that as a floating object over the matrix in a dashboard. Unfortunately the transparency can't be set to allow both the matrix and the total to show through.

Hi, Andreas

Please find my workaround to your case, though it is not meet all your requirement, you may consider as a temporary way before you could get any further solution.

Here is the result

To achieve above,

the first step is to union your data by itself

and then create below calculation fields

and then drag the calculation fields to the viz

and finally, change to dual axis and sync the axis

The workbook attached for your reference. Hope this could help

ZZ

HI Andreas, ZZ

Sorry for jumping in.

I did this without duplicating data, but one difficulty is align X-axis with whole number and decimal .

I tried to put big circle in the middle of range, but most of the case, the position is not the center, because I needed to put on top of existing data.

Anyways,

Some of calculation involve my over complication and I am lazy not to clean up those..

failure example

Thanks,

Shin

.

Hi friends,

I beg your pardon for jumping in with the view

slightly deviating from the original request.

Please find the attached.

Hope it could help.

Yours,

Yuri

Yuriy Fal , Shinichiro Murakami , you guys are legends.

ZZ

Hi Andreas,

One question to make things clear to me

Do you want to count Projects in each Quadrant,

or do you want to count Project Categories?

Yours,

Yuri

PS  Other questions may follow depends on your answer.

OK, then the next questions, please:

1) What level of detail (VizLOD) should be on a view?

Should each Mark represent a distinct [Project Name],

or should it be a distinct [projekt_category]?

2) How the [Project Risk] value should be calculated

when aggregated by the [projekt_category]?

Should it be weighted by [Project Volume],

or aggregated by some other calculation logic?

Please reply,

Yours,

Yuri