The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
User | Count |
---|---|
25 | |
12 | |
8 | |
8 | |
7 |
User | Count |
---|---|
27 | |
12 | |
12 | |
12 | |
6 |