Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have 3 tables: Global , Local , checklist . 1 global projects can have many local projects. 1 local projects can have many checklists. When I use the table visualisation It is only showing the projects which have data in global, local and checklist table. I somehow managed to show data from global and local and the global projects with no data in local are being shown blank which is great. But when I add the checklist to the table visual it is filtering out and only those projects which have data in all the 3 tables are being shown . I want to show all the projects and if they have no data in local and checklist I want it shown blank.
Solved! Go to Solution.
Hello @V24 ,
click on the project field and tick the show items with no data option
Proud to be a Super User! | |
Hey I am able to get all the data even when I add checklist data, but somehow even if I have data for certain columns it is not being shown. Ex if I have deployment lead in my datatable for all the projects it is not being shown in the table visual for all the projects it is showing for the ones with data in local and checklist
Hello @V24 ,
click on the project field and tick the show items with no data option
Proud to be a Super User! | |
Hi @Idrissshatila thanks, tried your solution, it does show all the projects when the data is only related to global and local when I put the checklist data the data is getting filtered and only the data having items in checklist is being shown. What do i do?
@V24 ,
can you show us how your data is structured and your scenario, I can't help you without knowing the structure of your model.
Proud to be a Super User! | |
@V24 ,
from which tables your data that you're trying to display are coming from?
Proud to be a Super User! | |
@Idrissshatila I am able to see the data when I add the checklist data to the table visual, but for some projects even if i have the data for some columns it is not being reflected in the table visual. Ex: if I have the completion %, deployment lead for all the projects in the global deployments field I am not able the see the completion % for some projects in the table visual. Here is an image for ex:
From the global deployments, local deployments and local checklist.
User | Count |
---|---|
121 | |
69 | |
67 | |
57 | |
50 |
User | Count |
---|---|
176 | |
83 | |
69 | |
65 | |
54 |