Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
is there any way to have a dynamic measure that will let me pick and choose individual values from two different columns and toggle between name or job title depending on which i would like to see? i know i can do this as a whole (either all fully showing names or all showing job titles) with a parameter but I am looking to do this on an individual level and have the rows be dynamic. ie: I want to see names under Accounting, but Job titles for Analytics. Snip of what the background data looks like below as well.
Name | Hours | Team | Month | Job Title | Department |
Diane Duke | 14 | Trident | 1/1/2026 | Commercial Analyst | Analytics |
Diane Duke | 9 | Trident | 10/1/2025 | Commercial Analyst | Analytics |
Diane Duke | 5 | Trident | 11/1/2025 | Commercial Analyst | Analytics |
Diane Duke | 11 | Trident | 12/1/2025 | Commercial Analyst | Analytics |
Diane Duke | 32 | Trident | 2/1/2025 | Commercial Analyst | Analytics |
Diane Duke | 25 | Trident | 2/1/2026 | Commercial Analyst | Analytics |
Diane Duke | 7 | Trident | 3/1/2025 | Commercial Analyst | Analytics |
Diane Duke | 31 | Trident | 3/1/2026 | Commercial Analyst | Analytics |
Diane Duke | 17 | Trident | 4/1/2025 | Commercial Analyst | Analytics |
Diane Duke | 35 | Trident | 4/1/2026 | Commercial Analyst | Analytics |
Diane Duke | 23 | Trident | 5/1/2025 | Commercial Analyst | Analytics |
Diane Duke | 31 | Trident | 5/1/2026 | Commercial Analyst | Analytics |
Diane Duke | 33 | Trident | 6/1/2025 | Commercial Analyst | Analytics |
Diane Duke | 32 | Trident | 7/1/2025 | Commercial Analyst | Analytics |
Diane Duke | 36 | Trident | 8/1/2025 | Commercial Analyst | Analytics |
Diane Duke | 3 | Trident | 9/1/2025 | Commercial Analyst | Analytics |
Hayden Guerra | 30 | Trident | 1/1/2026 | Computer Support Specialist | IT |
Hayden Guerra | 25 | Trident | 10/1/2025 | Computer Support Specialist | IT |
Hayden Guerra | 12 | Trident | 11/1/2025 | Computer Support Specialist | IT |
Hayden Guerra | 40 | Trident | 12/1/2025 | Computer Support Specialist | IT |
Hayden Guerra | 39 | Trident | 2/1/2025 | Computer Support Specialist | IT |
Hayden Guerra | 0 | Trident | 2/1/2026 | Computer Support Specialist | IT |
Hayden Guerra | 19 | Trident | 3/1/2025 | Computer Support Specialist | IT |
Hayden Guerra | 35 | Trident | 3/1/2026 | Computer Support Specialist | IT |
Hayden Guerra | 6 | Trident | 4/1/2025 | Computer Support Specialist | IT |
Hayden Guerra | 2 | Trident | 4/1/2026 | Computer Support Specialist | IT |
Hayden Guerra | 18 | Trident | 5/1/2025 | Computer Support Specialist | IT |
Hayden Guerra | 35 | Trident | 5/1/2026 | Computer Support Specialist | IT |
Hayden Guerra | 26 | Trident | 6/1/2025 | Computer Support Specialist | IT |
Hayden Guerra | 36 | Trident | 7/1/2025 | Computer Support Specialist | IT |
Hayden Guerra | 2 | Trident | 8/1/2025 | Computer Support Specialist | IT |
Hayden Guerra | 19 | Trident | 9/1/2025 | Computer Support Specialist | IT |
Renato Charles | 28 | Trident | 1/1/2026 | Controller | Accounting |
Renato Charles | 17 | Trident | 10/1/2025 | Controller | Accounting |
Renato Charles | 5 | Trident | 11/1/2025 | Controller | Accounting |
Renato Charles | 4 | Trident | 12/1/2025 | Controller | Accounting |
Renato Charles | 28 | Trident | 2/1/2025 | Controller | Accounting |
Renato Charles | 19 | Trident | 2/1/2026 | Controller | Accounting |
Renato Charles | 2 | Trident | 3/1/2025 | Controller | Accounting |
Renato Charles | 23 | Trident | 3/1/2026 | Controller | Accounting |
Renato Charles | 32 | Trident | 4/1/2025 | Controller | Accounting |
Renato Charles | 13 | Trident | 4/1/2026 | Controller | Accounting |
Renato Charles | 24 | Trident | 5/1/2025 | Controller | Accounting |
Renato Charles | 34 | Trident | 5/1/2026 | Controller | Accounting |
Renato Charles | 10 | Trident | 6/1/2025 | Controller | Accounting |
Renato Charles | 11 | Trident | 7/1/2025 | Controller | Accounting |
Renato Charles | 3 | Trident | 8/1/2025 | Controller | Accounting |
Renato Charles | 34 | Trident | 9/1/2025 | Controller | Accounting |
Brian Walker | 36 | Trident | 1/1/2026 | Executive Vice President | Management |
Brian Walker | 7 | Trident | 10/1/2025 | Executive Vice President | Management |
Brian Walker | 39 | Trident | 11/1/2025 | Executive Vice President | Management |
Brian Walker | 19 | Trident | 12/1/2025 | Executive Vice President | Management |
Brian Walker | 28 | Trident | 2/1/2025 | Executive Vice President | Management |
Brian Walker | 14 | Trident | 2/1/2026 | Executive Vice President | Management |
Brian Walker | 0 | Trident | 3/1/2025 | Executive Vice President | Management |
Brian Walker | 35 | Trident | 3/1/2026 | Executive Vice President | Management |
Brian Walker | 6 | Trident | 4/1/2025 | Executive Vice President | Management |
Brian Walker | 19 | Trident | 4/1/2026 | Executive Vice President | Management |
Brian Walker | 11 | Trident | 5/1/2025 | Executive Vice President | Management |
Brian Walker | 39 | Trident | 5/1/2026 | Executive Vice President | Management |
Brian Walker | 39 | Trident | 6/1/2025 | Executive Vice President | Management |
Brian Walker | 3 | Trident | 7/1/2025 | Executive Vice President | Management |
Brian Walker | 1 | Trident | 8/1/2025 | Executive Vice President | Management |
Brian Walker | 35 | Trident | 9/1/2025 | Executive Vice President | Management |
Solved! Go to Solution.
ie: I want to see names under Accounting, but Job titles for Analytics
That is not possible, not even remotely. Use separate visuals.
To create a dynamic measure that lets you toggle between "Name" and "Job Title":
Create a parameter table with options "Name" and "Job Title."
Create a DAX measure like this:
Dynamic Display =
SWITCH(
TRUE(),
SELECTEDVALUE('ParameterTable'[Display Option]) = "Name", SELECTEDVALUE('DataTable'[Name]),
SELECTEDVALUE('ParameterTable'[Display Option]) = "Job Title", SELECTEDVALUE('DataTable'[Job Title])
)
Add a slicer with the parameter table so you can toggle between "Name" and "Job Title."
https://help.zebrabi.com/kb/power-bi/dynamic-measure-switch/
If this response was helpful, please accept it as a solution and give kudos to help other community members
ie: I want to see names under Accounting, but Job titles for Analytics
That is not possible, not even remotely. Use separate visuals.
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |