Certain Data Missing from Excel Source

[F_Rehman2007]

 Hello,

I am working on a Power BI Dashboard where a single table Excel spreadsheet is the source of the data. This underlying spreadsheet has a list of subjects with various columns related to details for each subject.

All Subjects appear on the 'Slicer Attribute' which I have placed on the dashboard. For most of the subjects when I select them individually, their data does comes through from the underlying Excel spreadsheet and populates onto the relevant visualisations (Gauge and Card objects).

However, for a few subjects these same visualisations go Blank and no data is displayed despite that the data for these subjects DOES exist in the underlying Excel spreadsheet. There is no visible filter on these problematic subjects.

Please advise.

[v-jiascu-msft]

Hi @F_Rehman2007,

Are these data imported into Power BI? Can you see them in the data tab? Though they don't show up in the visuals, that may not relate to the data source.

Best Regards,

Dale

[F_Rehman2007]

The row count in the Data Tab (Power BI) = the row count in the Table in the Excel Source.

As I said I am working on a single page, but the Report itself contains several pages. When I look at the Relationships section, the Tables in the other pages are linked to the single Table being used in the page I am working on. So I don't know if they are somehow impacting the Table in my page.

[v-jiascu-msft]

Hi @F_Rehman2007,

Can you share the file or a dummy one?

The other tables (pages) could impact the result if you involve them in the visuals, filters or slicers. But we can't find out more without data.

Best Regards,

Dale