cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

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
Super User IV
Super User IV

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
Super User IV
Super User IV

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

Helpful resources

Announcements
secondImage

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

secondImage

Power BI Women

Join our monthly meetings and learning sessions.

secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors