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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Jansco
Helper I
Helper I

Is this possible using the SWITCH function or is there another way?

I followed the tutorial in this video ( https://www.youtube.com/watch?v=cgPnnPBwAq) and have been able to create a somewhat functioning version of a dynamic report in Power BI. When I click on various metrics ("Day over Day" and "Day over Week", etc) a table changes to include the metric selected. My question is, can I somehow include multiple columns within the SWITCH function? So, for example, when I click on the "Day over Day" BUTTON my table should change to include "Cost Day over Day" AND "Profit Day over Day", and so on.

Here is the code I am using:

Selected Metric = 
SWITCH( TRUE(),
    [Metric Selected] = "DoD", FORMAT([Total Cost DoD],0),
    [Metric Selected] = "DoW", FORMAT([Total Cost DoW], 0))

Or, another question might be, is there a way to return multiple columns of data using one measure?  Maybe a loop that will create multiple measures in one function?

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

Hi @Jansco,

 

On the table where you define the Metric Selected you can create a grouping level and used it as your slicer, so you should have a table with:

 

Level 1 Measure
Day Over Day Cost Day over Day
Day Over Day Profit Day over Day
Month Over Month Cost Month over month
Month Over Month Profit Month over month

 

Using the Level 1 on your slicer you will get both measures on your chart or visuals.

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

1 REPLY 1
MFelix
Super User
Super User

Hi @Jansco,

 

On the table where you define the Metric Selected you can create a grouping level and used it as your slicer, so you should have a table with:

 

Level 1 Measure
Day Over Day Cost Day over Day
Day Over Day Profit Day over Day
Month Over Month Cost Month over month
Month Over Month Profit Month over month

 

Using the Level 1 on your slicer you will get both measures on your chart or visuals.

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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