Need support

[Zakaria_1980]

Dears,

I need please your support, I have seen such report & I want to adapt it to my report. to do that, i'll need your support to guide me how i can, click on List of Oppro missing PEO, it will dsplay Tbl and if I click on the 2nd button List of Opprotunities with PEO i will have the same table but related to the 2nd button.

Thanks.

[Zakaria_1980]

the three above buttons are like sheets, the output will be the table below .

once you click on the first button, the table will include all data in the Tbl related to Opportunities misssing PEO. then if the user click on the second button, it will display the Tbl with data related to Opportunities with PEO and so on.

do you get my point?

[v-diye-msft · Accepted solution]

Hi @Zakaria_1980 

I believe the bookmark could work for this. refer to below official documents and related thread for more hints:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-bookmarks  

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-buttons  

https://community.powerbi.com/t5/Desktop/How-to-use-bookmarks-with-time-intelligence-functions/m-p/1... 

[Zakaria_1980]

Please I need another support to know how can i get the purcentage in the below snapshot just with 1 decimal or 0 decimals?

Thanks a lot.

[amitchandak]

@Zakaria_1980 , Not very clear to me, Are you looking for

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive