Forum Discussion

Lavery's avatar
Lavery
New Member
2 years ago

Table visual not displaying with certain slicers

Hi,

 

I've a table visual that has been working fine up until I tried to add new data. This table interacts with two slicers, one being regions and the other being months. 

There are 7 regions that can be selected, three of these seem to populate the table fine with all the data I've added. However, the other 4 populate up until the recent data, meaning with I select Midlands for August or September the table comes back blank. 

Midlands for July

Midlands for August

 

I've double checked all of the relationships and can't find the issue. Likewise checked the data table and all of the formats match.

Any ideas as to why this might be happening would be greatly appreciated.

 

Thank you,
Lavery

 

 

Need Help

1 Reply

  • jdbuchanan71's avatar
    jdbuchanan71
    Icon for Super User rankSuper User
    2 years ago

    Lavery 

    I am assuming you have a calendar table in your model linked to your data.  Check if the date column in your data is actually storing a Date/Time.  If it is, then the join to your calendar table will not find a match.

    You can convert a Date/Time to just a Date with this DAX (it's how I added the DateOnly column above)

    DateOnly = DATEVALUE(YourTable[Date])