Forum Discussion

CorneGeyser's avatar
CorneGeyser
Icon for Helper I rankHelper I
3 years ago

Visual Missing Data because of relationship

Hi,   I have a problem with a visual (matrix and line graphs) excluding data that has recently been added to the data source. I ma using an Excel sheet on OneDrive as the source for the data and I ...
Need Help
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

The measures you have in the visual must be returning blank. Post the code for the measures and we'll see if we can work out why.

CorneGeyser's avatar
CorneGeyser
Icon for Helper I rankHelper I
3 years ago

I do not have any measures for this visual.

 

The fields I have selected is all from the source table:

Also no filters on the page or visual:

When I create the exact same matrix on a new page it works fine. When I create a new page on the existing page, the error persists?

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    3 years ago

    Curiouser and curiouser ðŸ¤”.

    Use Performance Analyzer to get the query generated for both the working version and the non-working version. Have a look at both in DAX Studio and see what the differences are.

  • CorneGeyser's avatar
    CorneGeyser
    Icon for Helper I rankHelper I
    3 years ago

    I am so sorry for wasting your time. I have foudn the problem and it is so stupid.

     

    On my dashboard a have a hidden panel that contains slicers, one of them are the financial year and it is set to single select and the previous financial year was currently selected.

    I am honestly so sorry.

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    3 years ago

    No problem, glad you sorted it out.