Hello Dave,
You can easily achieve this by using Custom Data Points Appearance and write an expression.
For example, for the Pie chart, let’s say that you have category grouping by “Status”: =Fields!Status
For the Values, in order to count the rows for a certain status, in the Value field you should use: =Fields![RowCount]
In the Labels filed, you can use: =Fields!Status
That way, you can have the Statuses and their count in the chart legend. In the Legend tab >> Format filed use: <label> <value>
To use Custom Data Points Appearance for the pie slices:
From the Pivot tab >> Data Groupings >> Values >> Appearance tab, check “Use Custom Data Points Appearance”.
Then for the Fill and Border style, uncheck Automatic and for the Color field use an expression like this:
=IF(FIRST(Fields!Status) = "In-Control", "Red", IF(FIRST(Fields!Status) = "In-Progress", "Blue", IF(FIRST(Fields!Status) = "Closed", "Gray", IF(FIRST(Fields!Status) = "Opened", "Green", IF(FIRST(Fields!Status) = "Pending", "Yellow", "White")))))
Hopefully this helps.
Best Regards,
Nevron Support Team