Forum Discussion
How to filter graph to show only X-Axis values only where Y-Axis is equal to the legend?
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?
2 Replies
- lbendlin
Super User
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-p/963216
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 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
