March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
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.
Does anyone have a potential solution for this? Any help would be greatly appreciated, thanks!
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
25 | |
18 | |
15 | |
9 | |
7 |
User | Count |
---|---|
37 | |
32 | |
16 | |
16 | |
12 |