Forum Discussion

Helper II

5 years ago

Solved

Get data from Filtered rows

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
5 years ago
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

5 Replies

amitchandak
Super User
5 years ago
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
  Helper II
  5 years ago
  Thanks amitchandak
  but I dont think a measure will work, I need to display diferrent coulumns of the row.
Pragati11
Super User
5 years ago
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
  Helper II
  5 years ago
  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
    Super User
    5 years ago
    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