Forum Discussion

gra_197's avatar
gra_197
Helper II
9 months ago
Solved

Data not pulling through to visualisation

This is a headwrecking issue, apologies,    I have spreadsheets set up in sharepoint where people can provide updates accordingly. Each line has a date, year and quarter assigned so that I can brin...
Need Help
  • Anonymous's avatar
    Anonymous
    9 months ago

    Hi gra_197 ,

    Thank you for reaching out to the Microsoft Fabric Community Forum.

     

    Your visual shows data for Q2 2025 but not for Q3 2025. To resolve this, please verify that Q3 2025 data exists in your source Excel files and is loaded into the fact table, ensure the date table covers Q3 2025 with active relationships, and check for any page or report-level filters that might be affecting Q3.

    Also, confirm that the quarter values in the fact table exactly match the date table format, and perform a full dataset refresh. If the issue persists, sharing screenshots of your date table, relationships, and a Q3-filtered table visual will help us identify the root cause. Also thank you lbendlin  for your helpful response.

    Hope this helps. Please feel free to reach out for any further questions.

     

    Thank you.

     

Shubham_rai955's avatar
Shubham_rai955
Super User
9 months ago

The most common reasons data won’t appear for specific quarters in your table visualization are either missing or mismatched values in your source spreadsheet for the "Quarter" column, or issues with your date table relationship/filtering. Ensure that:

  • The "Quarter" and "Year" columns in your spreadsheet exactly match the values in your date table for Q3 2025—check for typos or blank cells.

  • Your date table covers all dates present in your spreadsheet, especially for Q3 2025.

  • Visual-level, page-level, or report-level filters are not accidentally excluding Q3 2025 data.

Fix source data issues, verify relationships and filters, then refresh the dataset, and your Q3 data should display correctly.