dynamic slicer flag column
1 Topic
Is it possible to use slicer selected value as flag column?
Context: I have one tables on PowerBI Activity: Date Store Sales Gross Margin 01/01/2021 Branch 1 10000 2000 01/02/2021 Branch 1 20000 4000 01/03/2021 Branch 1 15000 3000 01/04/2021 Branch 1 21000 4100 01/05/2021 Branch 1 30000 6000 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? Date Store Sales Gross Margin Flag 01/01/2021 Branch 1 10000 2000 1 01/02/2021 Branch 1 20000 4000 1 01/03/2021 Branch 1 15000 3000 1 01/04/2021 Branch 1 21000 4100 0 01/05/2021 Branch 1 30000 6000 0Solved3.1KViews0likes3Comments