Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

To add selection button to filter data in one graph

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.

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

@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

View solution in original post

9 REPLIES 9
Arentir
Resolver III
Resolver III

Hi @Anonymous,

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

 

Anonymous
Not applicable

Screen shot of simple model of itScreen 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.

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

Anonymous
Not applicable

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

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
Not applicable

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.

Capture.PNG
Anonymous
Not applicable

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 

Anonymous
Not applicable

@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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.