The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hi
I have a number of visuals where I have to know the latest value for. The approach I have been taking is using my mouse and hovering over the latest value to get the value. This isn't ideal for me. I would like to create a single number summary. I have seen single number summaries on dashboards but I do not know what they are called. What are they called? Here are some examples I found online:
How do I create these?
Thank you
Solved! Go to Solution.
Hi @mj2024 ,
Based on the description, creating the measure to get the latest value. Using the LASTDATE function to get the last date.
Latest date number =
CALCULATE(
MAX('Table'[Number]),
FILTER(
'Table',
'Table'[Date] = LASTDATE('Table'[Date])
//'Table'[Date] = MAX('Table'[Date])
)
)
Then, drag the measure to the card visual.
Pin the visual to the dashboard and move the tile to the top of the dashboard.
You can also view the following links to learn more information.
LASTDATE function (DAX) - DAX | Microsoft Learn
Solved: How to get value from last date (most recent) by c... - Microsoft Fabric Community
Solved: Show latest value on card - Microsoft Fabric Community
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @mj2024 ,
Based on the description, creating the measure to get the latest value. Using the LASTDATE function to get the last date.
Latest date number =
CALCULATE(
MAX('Table'[Number]),
FILTER(
'Table',
'Table'[Date] = LASTDATE('Table'[Date])
//'Table'[Date] = MAX('Table'[Date])
)
)
Then, drag the measure to the card visual.
Pin the visual to the dashboard and move the tile to the top of the dashboard.
You can also view the following links to learn more information.
LASTDATE function (DAX) - DAX | Microsoft Learn
Solved: How to get value from last date (most recent) by c... - Microsoft Fabric Community
Solved: Show latest value on card - Microsoft Fabric Community
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you so much @Anonymous !! It worked.
Use blank Buton , and then add measure to the blank button and you can apply below action mentioned in image
If it helps Kudos to work and Accept it as Solution.
Thanks for that. I am new to PowerBI. I am not too familiar with measures. All of the data has dates with them. I need to show the latest value for a particular field in a table. How would I do this?
User | Count |
---|---|
65 | |
61 | |
60 | |
53 | |
30 |
User | Count |
---|---|
180 | |
88 | |
71 | |
48 | |
46 |