CODEWITHSUNDEEP
powerbidaxpowerquery
Serdia
Serdia

Reputation: 4418

How to filter value in a card based on another chart in Power BI

I have Slicer InsurType, Pie Chart Premium by Division and Card that represents Budget On a picture below all InsurType are selected and Budget shows correct amount (101.4M).

enter image description here

If I choose parameter on a slicer, then the Budget value also represents correct amount (picture 2).

enter image description here

But now, if I click and choose value on a pie chart - then the Budget value will not be effected. I tried to change Edit Interaction but still - no effect.

So why the Budget value is not filtered by Pie Chart selection?

enter image description here

I am assuming its something to do with relationship that have "BudgetDate" table and "Divisions"

enter image description here

Divisions table looks like this:

enter image description here

Any advise how should I fix this issue?

Upvotes: 1

Views: 2432

Answers (1)

Alexis Olson
Alexis Olson

Reputation: 40204

It looks like there is no way for the Premiums table to affect the BudgetData table based on your diagram (look at the way the arrows are pointing).

I'd suggest editing the relationship to allow two directional filtering by changing the "Cross filter direction" from "Single" to "Both".

Filter Direction

Upvotes: 1

Related Questions