Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 😣.
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!!!
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |