Forum Discussion
Filters not showing the current time.
Hello, I am giving the latest data (Date time wise) in the card visulaization. I have to obtain the exact count of data in the drill down that is present in the crad visualization by putting date ...
Hi Anonymous ,
May I know how do you set the "drill down" and the filter for latest data in Filters pane? If you want to get the latest data on the latest date, you can refer the solution in the following threads to achieve it.
1. Create a column called MaxDate
MaxDate = CALCULATE(MAX(yourtablename[yourDatecolumn]),FILTER(yourtablename[Name]=EARLIER(yourtablename[Name])))
What this does is computes the MaxDate by Name and popluates in all records grouping by Name.
2. Create a column called IsLatest
IsLatest = If([Date]=[MaxDate],"Latest","Older")
3. Now create a report with relevant columns from yourtablename and use IsLatest column as a Visual Level Filter filtered for "Latest".
Best Regards