Forum Discussion
sagivh
Microsoft Employee
Microsoft EmployeeCard with only last day data
Hello, I have a trend that shows daily active users and I want to have a card showing only the last day of that trend, it seems the card has a filter by date but i need to pick a date and cannot set ...
Based on the filter context it takes last of that period and if no filter then it takes the latest date.
And its dynamic based on incremental data
sagivhMicrosoft Employee
Microsoft EmployeeThank you very much Amit, on the card the date doesnt appear on visualization, only the total data. if I add the datetime to my filters of that visualization I can only select an actual date to filter by and no LAST or MAX.
amitchandak
Super User
Super Usersagivh , I am not sure I got it. Now I am confused about what you need now. Card visual can show only one value. So it can be first, last or concatenated value
https://docs.microsoft.com/en-us/dax/concatenatex-function-dax
For more values, you have to choose other visual like table, charts or maybe multi-KPI