Forum Discussion

ElvirBotic's avatar
ElvirBotic
Helper III
1 year ago
Solved

Change relationship based on graph selection

Hello,    I am wondering if there i s a proper way to handle multiple relationships when a user selects a bar graph value to filter a table based off of that new relationship. Currently I have a da...
Need Help
  • pankajnamekar25's avatar
    pankajnamekar25
    1 year ago

    Hello ElvirBotic 

     

    You can achieve this using USERELATIONSHIP in a measure instead of changing the active relationship.

     

    ActualClosures =
    CALCULATE(
    COUNT(FactTable[ID]),
    USERELATIONSHIP(DateDim[Date], FactTable[ActualDate])
    )

    Use this measure in your table visualization.

    When a user selects a bar from the Actual Closures graph, it will filter based on Actual Date.

    No need for separate pages

     

    Thanks,
    Pankaj

    If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

     

     

Anonymous's avatar
Anonymous
Not applicable
9 months ago

I have two tables and create bar graph and scatter plot graph . I encounter an issue where when I click somewhere in the bar chart, the scatter plot also changes, but the table I use for both the bar chart and the scatter plot is not related. Both of the tables dont have any relationship and even in the model views , it doesnt show any relationship . I have try to format the interaction but it seems like when i click the bar graph , the scatter plot still go through changes .