Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Sankey transition visual

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 rang...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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's avatar
    Anonymous
    Not applicable
    3 years ago

    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