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
Anonymous
Not applicable

What If Paramteter Per Each Selection in Category

Hi All,

 

I have a dataset with several location

 

I have a slicer to select certain locations

 

Is there a possibility to assign a what if per location I choose?

 

Location

 

LA

Miami Select

NY Select    

Boston

Houston - Select

 

What if selection type ( Buy , Sell)

 

Miami = Sell

Ny = Buy

Houston = Buy

 

 so then I can

 

IF(Selectedvalue = "buy", [Measure Buy], [Measure Sell]

 

Any ideas?

1 ACCEPTED SOLUTION
mahoneypat
Employee
Employee

Yes.  You can make add a column with an IF or SWITCH to have Buy/Sell etc in the correct rows, or make a disconnected table with your slicer options and the Buy/Sell column.  You just need the slicer selection to filter the Buy/Sell column somehow.

You can then use MIN(SlicerTable[BuySellColumn]) in your expression in place of "selectedvalue".

Regards,

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

1 REPLY 1
mahoneypat
Employee
Employee

Yes.  You can make add a column with an IF or SWITCH to have Buy/Sell etc in the correct rows, or make a disconnected table with your slicer options and the Buy/Sell column.  You just need the slicer selection to filter the Buy/Sell column somehow.

You can then use MIN(SlicerTable[BuySellColumn]) in your expression in place of "selectedvalue".

Regards,

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


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.