I have a google forms that my warehouse manager fills out everyday to show how full the warehouses are. The google sheets is linked to Power BI no problem, but I need help getting the scorecards to display only the most recent row on the sheet and for the cards to show exactly what he input on the forms.
Solved! Go to Solution.
Hi @jakobd ,
What visual do you use for your scorecards in Power BI?
If you want to show the latest data in scorecards, you may creata a measure with Top N.
In addtion, I have a little confused about "show exactly what he input on the forms."
If it is convenient, could you share some screanshots and describe your scenario in more details.