Forum Discussion
Jeland
2 years agoRegular Visitor
Why SelectedValue has different return on Clusterred Chart and Card
I have a code to make a dynamic title in my clustered chart:
Selected Title =
VAR SCustomer = SELECTEDVALUE('QBODetailedProfitAndCogs'[Customer], "All Customers")
Return
SCustomer
Why is it when I select a specific customer in my Matrix table, the title in my clustered chart is always "All Customers" but when I checked the code using card, it changed to specific customer when I clicked specific customer in my Matrix table?
1 Reply
- vicky_
Super User
When you click on a specific customer, you're cross-filtering your other table. This is a built-in function in powerBI, which can often be really useful. Read this for more info: https://learn.microsoft.com/en-us/power-bi/consumer/end-user-interactions#cross-filter-and-cross-highlight
If you don't want to have your other visual affected by this, then you should turn off visual interactions between your Matrix and your cluster chart.