Forum Discussion

stino123's avatar
stino123
Icon for Helper II rankHelper II
2 years ago
Solved

Creating a path exploration visual in Power BI like that that exists in GA4 (decision tree)

I am creating a dashboard for an app that we have created. in the events of this app we have specific users and users will navigate through the app how they see fit. What the stakeholders wish to see...
Need Help
Tips and Tricks
Tutorial Requests
  • stino123's avatar
    stino123
    2 years ago

    The fix was creating a ranking based on a screen view event then creating 5 seperate calculated columns that identified the 1st, 2nd, 3rd... event as such. The second event needs to be inline with the non blank of the first event otherwise path exploration does not work. see below dax:

    1st event = IF('4. Fact_events'[RankScreenViews]=1,'4. Fact_events'[screen_name],BLANK())
    2nd event =
    VAR FirstScreenViewValue = '4. Fact_events'[1st event]
    VAR CurrentSessionID = '4. Fact_events'[session_id]
    VAR SecondScreenViewValue =
        CALCULATE(
            MAX('4. Fact_events'[screen_name]),
            FILTER(
                '4. Fact_events',
                '4. Fact_events'[event_name] = "screen_view" &&
                '4. Fact_events'[RankScreenViews] = 2 &&
                '4. Fact_events'[session_id] = CurrentSessionID
            )
        )
    RETURN
        IF(
            ISBLANK(FirstScreenViewValue),
            BLANK(),
            SecondScreenViewValue
        )
     
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Use a Decomposition Tree visual or a Sankey visual.

stino123's avatar
stino123
Icon for Helper II rankHelper II
2 years ago

lbendlin Decomposition tree won't work. you would need a column for first, second, third activity? same applies to a Sankey visual

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    No, Sankey works different. Only needs two columns.

    • stino123's avatar
      stino123
      Icon for Helper II rankHelper II
      2 years ago

      lbendlin This does not work because again you would need a measure for each next measure. Like the tree diagram it needs a new category each time...

      • stino123's avatar
        stino123
        Icon for Helper II rankHelper II
        2 years ago

        Further, You can have a duplicate dimension in a sankey visual which would be needed if you need to see each event.