The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to 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
Hi @Anonymous,
If you share your model, it would be easier to help.
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.
What is your selection button to filter? Month? Date? Or International or Local Sales?
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
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.
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,
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