Creating a stacked column in a chart and applying multiple filters

[Benedikt42]

Hello everyone,

I have a bar chart with the number of doctors in our database.

I can apply the following filters to it: Classification, Country, Indication, Journals, Societies, Specialisation. I can always apply these filters.

In addition, I have the following filters, let's call them Filter2: Publication Score, Expertscape Score, H-Index, Connected on LinkedIn, Player Score. When I want to apply these filters, I want to mark in the same bar chart what proportion of the total number of doctors are filtered by Filter2.

Example: I filter in Country for "Germany" and in Indication for "Lung Cancer". Now I want the bar chart to show me the number of German doctors who treat lung cancer. We call this number Result1.

I now filter in Player Score for "3". This filter is to be applied to Result1, i.e. I have the number of all German doctors who treat lung cancer and have a Player Score of 3. Let's call this result2.
Now I want the bar chart to show Result1 and Result2 in a different colour at the same time.

Is that possible?

Thank you for your support and kind regards

Benedikt

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...