Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
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
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.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
86 | |
85 | |
68 | |
67 | |
63 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |