Drill Down colors with the clustered column chart

[Anonymous]

I have been tasked with the following.  I work for a health care organization.  We have in network and out of network physicians.  I want to first display a chart showing a summary for all of the in and out of network physicians:

When I click on either of these, I want to see the physicians in the category and I want the physicians distinguished by color:

Is this possible?  I can't find a way to naturally do this.

[v-huizhn-msft · Accepted solution]

Hi @Anonymous,

For your scenario, I create the following sample table.



Create a measure using the formula: Count = COUNTA(Table1[physicians])

It impossible to drill Down colors with the clustered column chart. Because when you drill down, it shows all categories, rather than categories in per IN or OUT.



You can use Matrix Preview visual, when you click the button highlighted in red line, it display the details of category in per IN or OUT.


More details, please download the attachment and test.

Thanks,
Angelia