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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register 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
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

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! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.