Forum Discussion

Ismar's avatar
Ismar
Regular Visitor
4 years ago

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

  • 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.

    • Ismar's avatar
      Ismar
      Regular 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's avatar
        vojtechsima
        Icon for Super User rankSuper User

        Hello, Ismar 
        Make sure it looks like this and the Date Table is marked as "Date Table".