Forum Discussion
Hide the bookmarks Base on selected slicer Values
Hi Team,
Cayou please add some comments,
I have a requirement like, when ever I have selected Current FY I want show in Bars with Buttons incuded FYTD and 12 Months. But if I'm selected value FY2023 and FY2022 I dont want show FYTD and 12 Months Buttons.
Note 1) By using Below mesure we can Hide the text But Layer we can able to access If user click Layer bookmark funcanality working. we should hide the layers also if selected value FY2023 and 2022.
N = IF(SELECTEDVALUE(FiscalYear[Display Fiscal Year]) = "Current FY","12 Months",BLANK())
Like Below Image :
2) we can done this by using indivisual Book marks Fy2023,FY2022 and current Year But my slicer works on sync some other pages.
Regards,
2 Replies
- amitchandak
Super User
AjithReddy049 , Based on what I got. I doubt it as of now you can hide the button based on condition. You change color to transparent and try
refer
https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/
- AjithReddy049Frequent Visitor
Thanks for the response.
I have done transparancy By using the Below mesure.
N = IF(SELECTEDVALUE(FiscalYear[Display Fiscal Year]) = "Current FY","12 Months",BLANK())
But if I am selecting FY2023 and FY2022 then I can able to access the Layers of the 12Months and FYD.
we don't want layes Might be if I'm selecting the FY2023 and FY2022.
regards,Ajith ReddyS