Forum Discussion
Cross-highlighting based on measure
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
Thank you for your reply. Unfortunately, changing the chart type does not solve the issue.
Furthermore, I should add that I have tried substituting the boolean data with their corresponding numeric values (0 and 1) in the query, avoiding the need for custom measures. This did not solve the problem either.
I assume I need to use custom DAX formulas, but have been unsuccesful in writing something that works.
- Greg_Deckler
Community Champion
OK, can you give us a little more information about what each of the visualizations shows? I do not understand how you are getting to the numbers in your visualizations for Error Category, Impacts and Severity. If you could post some sample data in a format that can be copied and pasted into an Enter Data query and explain your formulas/aggregations, it would be much easier to recreate this and get to an answer.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
