I have the following stacked bar chart with the shown visualization settings:
Is there a way to show only the X-Axis values where the legend is the same as the Y-Axis?
Below is the sanitized sample data. The data is in two different tables and there is a relationship between the identifier columns in the two tables.
Table 1:
Source 1 | Identifier | OVIDs | OVIDs Affected |
IWI | 673648294 | 0000627e-47b1-42a3-80c4-540a0fd1c84e | 3 |
RDR | 0 | 0005a75d-a7ae-43ef-a2f5-d8dced82c4c0 | 3998 |
RDM | TBC | 0006b772-07ed-4f42-a986-3d98f02d8f07 | 102 |
iMeta | 3219 | 000bcbbb-0ac0-490f-a16d-d4dc44702439 | 3 |
SLU | 3219 | 000bcbbb-0ac0-490f-a16d-d4dc44702439 | 3 |
RDR | 0 | 001073d2-e711-4ce1-8c99-7b2c46087fdc | 3998 |
CCM | hdje1293 | 0010cc40-905a-49c6-9820-6401db860d9a | 4 |
IWI | 1hd829482s | 00114ad5-5182-43b1-a4f3-bc1bf4e3bb89 | 38 |
iMeta | 339499 | 001325a8-d5e2-4b21-8014-ce510016a679 | 3 |
Table 2:
Identifier | Count of Identifier | Source 2 |
ZC000018 | 1 | RDR |
ZC000018 | 4 | iMeta |
ZC000018 | 5 | SLU |
Z3113349 | 1 | RDR |
YA4610132 | 1 | RDR |
XXX | 1 | RDM |
XXX | 1 | RDM |
X123 | 2 | SLU |
X4931426 | 1 | RDM |
Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!