Sankey transition visual

[Anonymous]

Hi,

I want to dynamically filter table according to the date selected on the slicer. Is it feasible? If not, is there any workaround? I need to change "source" depending on the selected date range in "segment_date" field (eg when selecting date> 8/3/2022 in "source" it will show NEWLY_REGISTERED) . I need this solution to create sankey visual

Thanks for any advice

[v-rzhou-msft]

Hi @Anonymous ,

As far as I know, Power BI doesn't support us to return dynamic results by slicer in calculated column. Here I suggest you to create a measure to achieve your goal.

Firstly, please create an unrelated dimdate table by CALENDAR() or CALENDARAUTO() function.

Measure:

Source =
VAR _SELECTDATE =
    SELECTEDVALUE ( Dimdate[Date] )
VAR _MINDATE =
    CALCULATE (
        MIN ( 'Table'[segment_date] ),
        FILTER (
            ALLEXCEPT ( 'Table', 'Table'[persona_identifier] ),
            'Table'[segment_date] > _SELECTDATE
        )
    )
RETURN
    CALCULATE (
        MAX ( 'Table'[Destination] ),
        FILTER (
            ALLEXCEPT ( 'Table', 'Table'[persona_identifier] ),
            'Table'[segment_date] = _MINDATE
        )
    )

 Table visual:

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi, thanks it works really  good on the matrix/table but it is not possible to add measure as a source on sankey visual. Do you have any advice how to solve this one? thanks in advance