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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.