Forum Discussion
Partial Interaction Between Visuals
I am trying to figure out a way to have a filtered map visualization and pie chart interact with a matrix visualization partially.
I have rows of data by date with coordinates. In the matrix, the dates are the columns. The map and pie chart are both filtered to the top 1 date to only show the latest records. When data on the map or pie chart are selected, the interactions cause the matrix visual to be restricted to the latest date as well. I would like the date interaction to NOT filter the matrix, but still filter for the selected category or coordinates. Is that possible?
A (very) simplified example is here.
Normally it looks like this:
When I make selections on the map or pie chart, the interactions filter the matrix like this:
I would like it to be like this, if for example Category C was selected:
So that it shows all dates, but only the selected category or location.
Is this possible? I'm hoping there's a workaround with measures!
Hi ELW ,
Consider creating a new Date table and using it as a column in a matrix:
Then please crate this measure and use it as matrix's value:
Measure = VAR __cur_date = SELECTEDVALUE('Date'[Date]) VAR __result = CALCULATE(SUM('Table'[Value]), 'Table'[Date]=__cur_date,ALLEXCEPT('Table','Table'[Category])) RETURN __resultResult:
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
2 Replies
Hi ELW ,
Consider creating a new Date table and using it as a column in a matrix:
Then please crate this measure and use it as matrix's value:
Measure = VAR __cur_date = SELECTEDVALUE('Date'[Date]) VAR __result = CALCULATE(SUM('Table'[Value]), 'Table'[Date]=__cur_date,ALLEXCEPT('Table','Table'[Category])) RETURN __resultResult:
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
Thank you, Anonymous - I believe that's working!!
