Forum Discussion
Helper ISlicer and switch selection
Hi,
I have a table with "Projects" - "Clients" - "Sales"
I would like to display a graph showing sales only by Project or Client using a slicer.
If a select Project the graph will be sales by Project, If a select client the grpah will show sales by Client.
Can someone help me
thank you
Hi azizdoghmi
One way: You may use bookmarks and buttons to achieve that like this article.
Second way: You may create tables and measures like this post.
Third way: Please refer to this post to create the tables.
Here is the similar post about second and third ways for your reference.
https://community.powerbi.com/t5/Desktop/Dynamic-change-in-X-Axis/td-p/86167
Regards,
Cherie
2 Replies
v-cherch-msftMicrosoft Employee
Hi azizdoghmi
One way: You may use bookmarks and buttons to achieve that like this article.
Second way: You may create tables and measures like this post.
Third way: Please refer to this post to create the tables.
Here is the similar post about second and third ways for your reference.
https://community.powerbi.com/t5/Desktop/Dynamic-change-in-X-Axis/td-p/86167
Regards,
Cherie
azizdoghmiPerfect! Thank you!