Forum Discussion

thanhnc1's avatar
thanhnc1
New Member
4 years ago

SELECTED FIRST ROW TO SHOW

Hi!!!
I just want to display default the first row (top 1) in the table to cards instead of blank or min or sum cause in the table, I have sort the value by rank.
For instance: when enter to the sheet, the cards will show the first row of the table and the value of card will change whenever you click another row in table. I have used syntax: isfiltered, selectedvalue, firstnonblank but it work didnt like the way I want 😣.

  • My table

  • Cards

You can see it not display the value of first row in table, the default display of card that I want is:

And it can change the value whenever I choose another row of table:

  

Pls helpme. Thanks!!!

 

Need Help

1 Reply

  • jsaunders_zero9's avatar
    jsaunders_zero9
    Responsive Resident
    4 years ago

    Hi thanhnc1 ,

    You could contstruct the measures in the cards with HASONEVALUE, if the table has more than one selection then return only the FIRST result else return the selected value.

    If you can mock up some sample data in a pbix I can show you what I mean.

    Thank you