slicer for filter out item belongs to multiple categories

[Anonymous]

Hi Community,

I am looking for some help, my goal is to have a slicer and a graph when I choose New Sales Dashboard from the slicer Customer POS will show in the graph and when I choose Forecast report Customer POS will also show on the graph.

Hope anyone can help?

Thank you! 

I 

[amitchandak]

@Anonymous , Not very clear. But Seem like case bookmarks.

Can you explain with an example.

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

[Anonymous]

@amitchandak 

Sorry let me clarify, I have a data set like the one I posted and it have multiple.  Each Initiative linked to either just one or more program.  I want to have a slicer that show program 1 and 2 as choice.  In my visualization, when choose Forecast report or New Sales Dashboard I want Customer POS to be show as the result. so basically is there are 2 program related to the same initiative.

Hope this help.

[v-diye-msft]

Hi @Anonymous 

It seems you can use the hierarchy slicer to manage the program 1 & 2 in the slicer, and based on the relationship in your table above, it should work.

If not the expected results, you might consider providing your dummy pbix that would be helpful for us to investigate it further. 

You can upload it to the onedrive for business and share the link here. please don't forget to disclose the expected results and remove the confidential info.

[Anonymous]

Hi @v-diye-msft  thank you for your help,  the solution you suggest seems not able to get what I am looking for.

Here is a more detail of the sample data.  

I have Multip Epic, and each Epic linked to multiple program and each program can link to multiple initiative. each Sub program can link to multiplet initiative

Epic	Program	Initiative	Sub Program
Epic 1	PG1	Project 1	SP1
Epic 1	PG1	Project 2	SP1
Epic 1	PG1	Project 3	SP2
Epic 1	PG2	Project 4	SP2
Epic 1	PG 3	Project 5	SP2
Epic 1	PG4	Project 6	SP2
Epic 1	PG4	Project 7	SP2
Epic 1	PG5	Project 8	SP2
Epic 1	PG5	Project 9	SP2
Epic 1	PG5	Project 10	SP3
Epic 1	PG5	Project 11	SP4
Epic 2	PG6	Project 12	SP1
Epic 2	PG7	Project 13	SP1
Epic 2	PG8	Project 14	SP4
Epic 2	PG8	Project 15	SP4
Epic 3	PG9	Project 16	SP4
Epic 4	PG10	Project 17	SP4
Epic 5	PG11	Project 18	SP1
Epic 5	PG12	Project 19	SP4
Epic 5	PG12	Project 20	SP4
Epic 5	PG12	Project 21	SP5
Epic 5	PG12	Project 22	SP6
Epic 5	PG12	Project 23	SP6
Epic 5	PG13	Project 24	SP7

What I am trying to achieve is I will have a Gantt chart to show all the Sub Program progress. if I click on Epic 1 on the slicer it will able to show all related Sub program. Hope anyone can help!