Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
StanHost12
Regular Visitor

Multiple Buttons Based on One Dax Measure

Hello!

Background:

I am relatively new to Power BI and Dax and have had issues understanding the way Dax works sometimes. The visualization I am making has buttons that lead to other pages. I have functional page navigation buttons that are based on what is selected in the filter/slicer above it (using a SWITCH statement and/or an IF statement). I want it to be better/more modular and efficient by making all of the buttons be based on the same page navigation measure rather than one measure for each button.

Example:

When performance measure 4-1 is selected I want Button 4 to function and be able bring me to a new page if I were to click on it, and if I were to click on Button 3 it would not do anything (keep me on this page).

If performance measure 3-1 is selected I want Button 3 to being me to a new page it leads to if I click on it while Button 4 doesn't function (keeps me on this page).

I can do this with individual measures.

With a singe measure used for both I can only right now, through a SWITCH function, make it so if neither (3-1 or 4-1) are selected neither button takes you anywhere. If 3-1 is selected both buttons take you to the page intended for just Button 3. If 4-1 is selected both buttons take you to the page intended for Button 4.

StanHost12_0-1730905114535.png

 

Does anyone have a potential solution for this? Any help would be greatly appreciated, thanks!

 

1 REPLY 1
lbendlin
Super User
Super User

I have functional page navigation buttons that are based on what is selected in the filter/slicer above it (using a SWITCH statement and/or an IF statement). 

Your job as  a developer is to put as few clicks as possIble between your users and the insights.  "Page navigation"  is not a productive element in that job.  Rethink your approach, eliminate the buttons, use the standard navigation features the way they are intended to be used.

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.