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 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

Need Help
Tips and Tricks

2 Replies

  • 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