Forum Discussion
Force relationship between visuals
Hi – I built a waterfall chart in Power BI in which the user can see what changes happen within a selected time period within a SCD2 opportunity table.
The waterfall is built using a SWITCH statement to allow each bucket to be calculated using different measures.
Given how this was built, there’s no way to click on a waterfall bucket to see the detailed results in a separate table. Is there any way to force this interaction to happen? Possibly by adding a measure to the detail table visual to force a “relationship”?
Pipeline Waterfall Amount =
VAR PipelineStart = [0_Pipeline Start]
VAR New = [01_New]
VAR Reopen = [02_Reopen]
VAR Expand = [03_Expand]
VAR MovedIn = [04_Moved In]
VAR MovedOut = [06_Moved Out]
VAR Reduce = [07_Reduce]
VAR ClosedWon = [08_Won Not New]
VAR ClosedWonNew = [09_Won New]
VAR ClosedLost = [10_Lost Not New]
VAR ClosedLostNew = [11_Lost New]
VAR Deleted = [12_Delete]
VAR PipelineEnd = [99_Pipeline End]
VAR Result =
SWITCH(
SELECTEDVALUE('Pipeline Waterfall'[Value]),
0,PipelineStart,
1,New,
2,Reopen,
3,Expand,
4,MovedIn,
6,-MovedOut,
7,-Reduce,
8,-ClosedWon,
9,-ClosedWonNew,
10,-ClosedLost,
11,-ClosedLostNew,
12,-Deleted,
13,PipelineEnd
)
1 Reply
- AnonymousNot applicable
Hi, hrafnkel11
Based on the information you provided, it's not clear what data your Y-axis is populated with, and you still have a lot of [Measure],for the time being, I can't reproduce the inability to interact, you can provide pbix files with no sensitive data for testing purposes.Best Regards,
Yang
Community Support Team