Forum Discussion
stino123
Helper II
Helper IICreating 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...
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))RETURNIF(ISBLANK(FirstScreenViewValue),BLANK(),SecondScreenViewValue)
