Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
The visual is providing user to interact with the data using the parameter. they can select parameter value(DueInDays)ranging from 1-30 days and then see the number of jobs due as per selection.
For eg ; if the user is selecting 3 , they will be able to see the number of jobs due in next 3 days .
Logic behind :- In tableau i am passing the parameter value selected by the user in one of the calculated field :
IF [Status] <> "Completed" THEN
if(DATEDIFF('day',DATEADD('day',int([DueInDays]),NOW()), [Due Date])<0 AND isnull([Date Completed]))
THEN "Overdue"
ELSE "Not Due"
END
ELSE
"Completed"
END
and its helping the view to update everytime user is selecting different value .
Try like
IF ([Status] <> "Completed" ,if(datediff(Today()+ ([DueInDays]*1), [Due Date],day)<0 && isblank([Date Completed]), "Overdue"
, "Not Due"
)
,
"Completed"
)
Hi Amit,
I created the new column but the values are not changing when I am updating the DueInDays parameter value from the report view .
Then you need a measure.Can you share sample data and sample output. If possible please share a sample pbix file after removing sensitive information.Thanks.
@Anonymous
You need to rework it as measure, something like this and context would (row) also be important
IF (firstnonblank([Status],blank()) <> "Completed" ,if(datediff(Today()+ (max('DueInDays'[DueInDays])*1), [Due Date],day)<0 && isblank(firstnonblank([Date Completed],blank())), "Overdue"
, "Not Due"
)
,
"Completed"
)
Refer how to manage row context in my blog
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |