Forum Discussion
Cross-highlighting based on measure
- 8 years ago
Hi Jero,
In your scenario, click one bar in in "Impact(s)" funnel chart cannot filter the other two bar charts. This is by design. Because you added serveral columns ([NonRecuperableLoss], [RecuperableLoss], [PotentialFutureLoss], [Gain] and [PotentialFutureGain]) into funnel chart, when you clicked one bar in funnel chart, actually, you were making column level filters. This operation didn't filter out any record row in other two charts. That is why the other two charts are not filtered, they supports row level filters.
When you select [Gain] in funnel chart, all record rows are available.
When you select [High] in column chart, only highlighted rows are available.
An other example for your reference, if you create funnel chart like below.
When clicking a bar in this chart (e.g. True), it can affect other two charts.
Best regards,
Yuliana Gu
And the auxiliary table tblSortOrder:
SortOrder;severitySort
1;Low
2;Medium
3;High
4;Very high