Forum Discussion

ELW's avatar
ELW
Advocate II
1 year ago
Solved

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, t...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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
__result

    Result:

    Best Regards,
    Gao
    Community Support Team

     

    If 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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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
__result

Result:

Best Regards,
Gao
Community Support Team

 

If 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