Forum Discussion
Data changes after click row
I'm hoping someone much smarter than I am can help. I have 2 tables shown on a report. Clicking on the row of 1 table makes that data in the second table disappear despite the data being tied to the row. Please help.
Top image row not clicked, bottom image row clicked.
Are the data from two visuals coming from the same fact_sheet? If not, better check the relationship diagram. I'm making a bold guess: could you use one dim_date table and link it to [ActiveDateTime] and [CreatedDate]? If that's the case, the interaction will cause 2nd table to disappear.
6 Replies
By default, there is interaction between visuals on the same page, meaning when you click one row in one table, the filtering context is passed to other visuals on the page.
Here is video about interaction and how to de-activate it.
Yeah I understand that and that's what I want to happen. But in this instance that record is tied to the record below and should still show when clicked on. However it does not. Also not that the count of property goes to blank when selected. That should not be possible.
Are the data from two visuals coming from the same fact_sheet? If not, better check the relationship diagram. I'm making a bold guess: could you use one dim_date table and link it to [ActiveDateTime] and [CreatedDate]? If that's the case, the interaction will cause 2nd table to disappear.
