Slicer and switch selection

[azizdoghmi]

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

[v-cherch-msft · Accepted solution]

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

[azizdoghmi]

Perfect! Thank you!