March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I have a table where I have a list of tasks that need to be done, linked to dates of my teams agenda different source table
Now the interesting thing is to see what tasks are not assigned yet by date and who.
I can see them when I ask show items with no data, but then I only want to see those task with no corresponding date assigned or person assigned to it from the agenda. When I add a filter on date is empty or blank or assigned to is blank/empty the whole table goes away. When I use an advanced filter show items when value is not blank it will filter out all the blanks, when I filter is blank again whole table is empty.
@Daanneut , Assume your task in table1 Table1[Task] and related data in table 2 say Table2[Date]
Then create a measure like this and plot with Table1[Task] , if these are related tables, for tasks with no record
calculate(if(isblank(count(Table2[Date]))),1, blank())
Hi, thank you for your reply! So the tasks come from a different source then the date and assigned I linked them because in the agenda we assign the same task names to a date and person. I have noticed we are missing out we think we have assigned tasks but it is in no persons agenda. Now I can see the task that have no corresponding date/person assigned to them but also I see all that have. And I wanted it to be clean and only show the tasks that did not get assigned. Problem is that my Agenda source does not have empty items because it does not yet exist
@Daanneut ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi @amitchandak
https://www.dropbox.com/s/txz2ljyke1sl94k/AD%20data%202021%20rev3.pbix?dl=0
This is the complete file I am mainly working now on page 1 to try and work it out
@Daanneut , upload of onedrive or dropbox and share a link
Hi Amitchandak,
Still strugeling with this issue I have a full report were I have the list of taks that did not yet get a execution date. But still would only like to show the ones that do not have that date. Not all taks.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
88 | |
78 | |
65 | |
59 |
User | Count |
---|---|
140 | |
122 | |
105 | |
94 | |
90 |