Switch 3 measures with one click

Hi Varshi288 ,

Yes, you can achieve this without using bookmarks by creating a “helper” table and a dynamic measure that responds to the toggle switch selection.

Here’s how you can do it:

1. Create a Helper Table for the Toggle

   • In Power BI, go to “Enter Data” and create a table like:Switch

     Old

     New

   • Name this table something like “ToggleTable”.

2. Add a Slicer

   • Add a slicer visual to your report using the “Switch” column from the “ToggleTable”. This will act as your toggle.

3. Create a Dynamic Measure

   • Write a measure that checks the selection and returns the appropriate values. For example:
   DAX
    

   Selected_Measure =
   VAR Toggle = SELECTEDVALUE(ToggleTable[Switch])
   RETURN
   SWITCH(
       TRUE(),
       Toggle = "Old", [Old_Measure],
       Toggle = "New", [New_Measure],
       BLANK()
   )

   • If you want to switch between multiple measures, you can expand the SWITCH logic to include more options.

4. Use the Dynamic Measure in Your Visuals

   • Add the “Selected_Measure” to your table or matrix. It will now update based on the slicer (toggle) selection.

Advantages:

• This method works across all pages and respects the filter context.
• No need for bookmarks, so it’s much easier to maintain.

Let me know if you need example DAX for your specific measures or more detail on any step!

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
translation and formatting supported by AI

burakkaragoz  Thank you for you quick response By expanding the switch logic it still shows only one measure. If i select Elim from the slicer it should show 3 measures TP_$,TP CM Scope and TP CM %. 

Hi Varshi288 ,

I want to check if you had the opportunity to review the information provided and resolve the issue.If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.