Maps, Tables and Data

[stevessestari]

Hello,

1. We have a map that displays the location with latitude and longitude, it needs to display only the last latitude and longitude of the table (based on the most current Timestamp) and not all of them (our map appears full of bullets). For this case you can create a DAX Measure using some formula?

2. We have a table that displays multiple columns and like that the line that has certain value in column stayed in red, is it possible? Ex: When the X column has value Y entire line that has such value should be in red color, in this case we try to use the Conditional Formatting more this option appears only for other fields.

3. There is the possibility to display any image regarding the condition value. Ex: If value is equal to 0 to display image with the following URL, if value is equal to 1 show toher image with other URL?

Thanks in advance,

[ankitpatira · Accepted solution]

@stevessestari 

1. I would say use create table under Modelling tab option and use below code to get max values for datetime,

Table = FILTER(TABLENAME, TABLENAME[datetimeColumn] = MAX(TABLENAME[datetimeColumn]) )

2. Conditional formatting is only applicable for fields that are type numeric so you can't do something like parse string to find certain value 'Y' and show it in red. I don't think that level of formatting is possible currently.

3. You can have two image URL columns and create other calculated column with IF condition so show either url from URLColumn1 or URLColumn2 based on condition.

[stevessestari]

Hi ankitpatira,

Thank you very much for your help, i was able to filter the table and to transform my column in number. In the case of images, I will test and use in my next project.