Forum Discussion
Cross-filtering not showing all data
Hello,
this is my issue. I have a table visual with budget and actual figures. As additional 2 visuals, I have budget and actual distributed by months.
So, what happens is this. When I select a couple of months in budget visual, table is properly filtered and it shows correct budget total for those months. When I do the same with actual visual, a table is again correctly filtered, and it shows actual only for those selected months. But, when I filter by both, selecting same months in budget and actual visuals, table gets filtered in a way that it shows budget figures only for those raws having a result in actual. So a total of budget is less than it should be. It does not show the categories where I have budgeted values, without actual. I switched on "Show items with no data", but no effect.
My budgeted values are coming from an excel table as a source, and actual is coming directly from SQL. So, this combination oftenly does not retrieve proper results, like in this case.
I hope I explained this in an understandable way.
Thanks in advance!
9 Replies
- vojtechsima
Super User
Hi, Ismar
Do you have Date Table that would link each table on its own by One-Many relationship? (One = Date Table).
If not, I suggest you first create one and then try it again.- IsmarRegular Visitor
Hello, I didn't have that. I created it now, but no luck, same result. I didn't manage to create active single-to-many relationship with both tables though. Only one can be active. And which ever it is, it filters the same.
- vojtechsima
Super User