Forum Discussion
Creating a stacked column in a chart and applying multiple filters
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
1 Reply
- lbendlinSuper User
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-Forum/ba-p/963216
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/1447523