Disable / Enable Button

[DanielLinda]

Hi All,

I made button to go other page, but I want to make button enabled only when user select one value from slicer.

Is there any way to control button to disable / enable?

Thanks in advance.

[Keith_Fernandes]

Hi 

I may be very late to this but I have a solution if you are still looking for one.

For example, if your slicer is built on country name-

And I have buttons to navigate to the pages-

Next as per your requirement, I have created a measure in the dim_product table as below-

logic = if(ISCROSSFILTERED(dim_country[country_name]),"Country Analysis","")

Next I go to the button and assign this measure to the action setting under page navigation.

You are good to go.

[parry2k]

@DanielLinda check this post that talks about it. In this post, it shows how to enable/disable button

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

[Anonymous]

@parry2k  Do you think I can do the same thing with navigation button?

I followed the post, created the measure and it works great but when it button of type navigation I dont manage to disable it when the conditions are not met. the button dosent do anything but its not disabled

[DanielLinda]

Thanks @parry2k,

It looks great, I didn't realize the function in Power BI desktop.

Is it possible only from Power BI service?

[parry2k]

@DanielLinda not sure what you mean, only from Power BI Service?

[DanielLinda]

Sorry, can I use the feature in the Power BI Desktop as well?

As I know some of the features are not usable in Power BI Desktop.

[parry2k]

@DanielLinda it will work, did you actually tried it or asking questions. Everything is there, well documented for you to test. You can ask as many questions as you want but you have to test before asking the next questions. Just feedback.

[DanielLinda]

@parry2k 

Yup, sure I will.

I'll follow your suggestion.

Thanks 🙂

[DanielLinda]

I'm trying what you infromed, but I cannot use "SELECTEDVALUE" function and the error shows like below.

I cannot understand why the function cannot be found in my environment since I'm just following as same as the document.

Please give me any solution about it.

[DanielLinda]

I succeeded to use HASONEVALUE function rather than SELECTEDVALUE.

However, the disabled drill through button just control text not action.

Is there no option to make user cannot click button?

Thanks so much.

[v-yiruan-msft]

Hi @DanielLinda ,

I'm not clear about your required? Do you want to all of the report consumers can't click this button? If yes, then this button is meaningless...

Best Regards

Rena

[DanielLinda]

No, I want to control the button by selected value from slicer.

If user doesn't select any value from slicer, the button should be disabled(even though user click the button, any action should not work.).

When user select value from slicer, user can go other page by clicking the button.

Thanks.