Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Let me know if I havent explained myself well.
Solved! Go to 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
Hi @JSR ,
You can do it easily by having a filter on CATEGORY and a Multicard to display relevant information.
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
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.
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
@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))
Thanks @amitchandak
but I dont think a measure will work, I need to display diferrent coulumns of the row.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
90 | |
81 | |
65 | |
65 | |
61 |
User | Count |
---|---|
170 | |
114 | |
102 | |
73 | |
69 |