Forum Discussion

PowerToTheBiz's avatar
PowerToTheBiz
New Member
3 years ago
Solved

Customization of interactions

Hello @all,

is there a possibility to edit interactions (clicking on an item in visual 1 interacts with visual 2) even deeper, than just "filter", "highlight" or "none"?

I have an example:
Visual 1: Show me the top 10 customers and show me their current YTD revenue (in other words: filter on current year = 1) as a bar chart.

Visual 2: Show me the sum of all revenues as a line for each month for the current AND the previous year.

My problem: When I click on a customer in visual 1, the filter "current year = 1" gets applied in visual 2, as well as the filter on the customer. I don't want the "current year = 1" filter to get applied.

Does anyone see a way to solve this, so visual 2 is only filtered on the customer?

 

Thanks in advance for your thoughts!

Need Help
  • Anand24's avatar
    Anand24
    3 years ago

    Hi PowerToTheBiz ,
    For this to happen, you will have to write a dax code to add revenue while ignoring year filter. You will have to use ALL function so that "Year" field is ignored.

    New_Revenue = CALCULATE(SUM(Revenue), ALL(TableName[Year]))

     

    Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

    Proud To Be a Super User !!!
    LinkedIn

2 Replies

  • Anand24's avatar
    Anand24
    Icon for Super User rankSuper User
    3 years ago

    Hi PowerToTheBiz ,
    For this to happen, you will have to write a dax code to add revenue while ignoring year filter. You will have to use ALL function so that "Year" field is ignored.

    New_Revenue = CALCULATE(SUM(Revenue), ALL(TableName[Year]))

     

    Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

    Proud To Be a Super User !!!
    LinkedIn