cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
emmanuelvallejo
Frequent Visitor

Is it possible to use slicer selected value as flag column?

Context:
I have one tables on PowerBI
Activity:

DateStoreSalesGross Margin
01/01/2021Branch 1100002000
01/02/2021Branch 1200004000
01/03/2021Branch 1150003000
01/04/2021Branch 1210004100
01/05/2021Branch 1300006000


I have a Date slicer having the list of dates on this table.
I need to add a column indicating if the date is before or on, from the value selected on the slicer,
For example if 01/03/2021 is selected on the slicer I want this flag column:
This column needs to be dynamic, is this possible?
 

DateStoreSalesGross MarginFlag
01/01/2021Branch 1100002000

1

01/02/2021Branch 12000040001
01/03/2021Branch 11500030001
01/04/2021Branch 12100041000
01/05/2021Branch 13000060000
1 ACCEPTED SOLUTION
stevedep
Super User I
Super User I

Hi @emmanuelvallejo ,

 

Assuming its semantics, and that you don't mind that its a measure, yes, its possible. Please see below:

stevedep_0-1614489403729.png

Hope that this works for you?

 

Kind regards, 

 

 

Steve. 

 

View solution in original post

3 REPLIES 3
stevedep
Super User I
Super User I

Hi @emmanuelvallejo ,

 

Assuming its semantics, and that you don't mind that its a measure, yes, its possible. Please see below:

stevedep_0-1614489403729.png

Hope that this works for you?

 

Kind regards, 

 

 

Steve. 

 

View solution in original post

Hello Steve,
It works this way, I guess I can move forward on the solution using it.
Thanks for you reply and example 

lbendlin
Super User III
Super User III

No. You can only modify measures based on filter selections. calculated columns are not impacted by filters.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors