To add selection button to filter data in one graph

[Anonymous]

Hi,

I have been using two graphs to show two different values from two charts for same time line.

Now i am looking to make a selection button to filter which value i want to show in one graph,

Could someone please recommend me a way to do it.

[Arentir]

Hi @Anonymous,

If you share your model, it would be easier to help.

[Anonymous]

Screen shot of simple model of it

Hi,

Hope this screen shot will be showing enough for what i am reffering to since i don't know any other option to share my pbix file.

[cjayaneththi]

What is your selection button to filter? Month? Date? Or International or Local Sales?

[Anonymous]

Selection button should include two names as Local Sales and International Sales

[cjayaneththi]

o.k You need to have the lookup table for that and look up table should link(one to many)to fact (local & International) tables

[Anonymous]

Okay , exactly that is what i want to know how can i create a lookup table if you can provide simple guidlines or simple model it would be a great help to me.

[cjayaneththi]

---

[Anonymous]

But i still have the same issue, How may i be able to create lookuptable ,  Can you share the file you made or a link 

[v-yuezhe-msft · Accepted solution]

@Anonymous,

You can use bookmark to achieve the above requirement. For more details, please review the example in attached PBIX file. And you can check detailed steps in the following video.

https://www.youtube.com/watch?v=_Afcj8mT5_Q

Regards,
Lydia