Get data from Filtered rows

[JSR]

Hi,

A bit lost on how best get data from specific rows so looking for any advice, thanks.

Having a table like below.

I would like to get specific filtered rows and display its info into cards.

So 1st card shows data where Category = IT and current date between Start and end date.

• I guess I don't need to modify the model data,but how can I get the data filtered by category and by dates?

Let me know if I havent explained myself well.

[Pragati11]

Hi @JSR ,

You can do it easily by having a filter on CATEGORY and a Multicard to display relevant information.

• Create a Slicer and move Category column to it.
• Create a Muti-card and move Title, Category, End Date columns to it.

Now whenever you change values in the slicer, the values in the card visual gets updated:

Let me know if this what you are looking for.

Thanks,

Pragati

[JSR]

Thanks @Pragati11 for your super detailed answer.

But I need to do the filtering automatic, and only display the latest based on Category and dates.

[Pragati11 · Accepted solution]

Hi @JSR ,

For TITLE column, set summarisation to FIRST as highlighted below:

For END DATE, set summarisation to LATEST as shiwn below:

This will give you your desired result as follows:

Thanks,

Pragati

[amitchandak]

@JSR , Try a measure like

measure =
var _date = today() //selectedvalue(date[date])
return
calculate(counrows(Table), filter(Table, table[start date]<=_date && Table[end date]>= _date))

[JSR]

Thanks @amitchandak 

but I dont think a measure will work, I need to display diferrent coulumns of the row.