Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
powerbiguy_
Frequent Visitor

How to display the peak value and date on card

I've been trying to display the peak value and date based on a graph. In my sample, I want to display 432,769.65 and 30-Tue.

powerbiguy__1-1692085128198.png

 

1 ACCEPTED SOLUTION
Kishore_KVN
Super User
Super User

Hello @powerbiguy_ ,

I agress with @Ritaf1983 solution but if you want without clicking a point, then you should create measure as below depends on the maximum value card visual will update automatically. 

Here is the sample data that I considered:

Kishore_KVN_0-1692161386176.png

 

Your calculated measure looks as below:

Card Measure = 
Var a = MAX('Table'[Sales])
Var b = LOOKUPVALUE('Table'[Date],'Table'[Sales],a)
Return
"Maximum Sales are: "&a& UNICHAR(10)&"On: "&b

Output looks as below:

Kishore_KVN_1-1692161445159.png

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

 

View solution in original post

3 REPLIES 3
Kishore_KVN
Super User
Super User

Hello @powerbiguy_ ,

I agress with @Ritaf1983 solution but if you want without clicking a point, then you should create measure as below depends on the maximum value card visual will update automatically. 

Here is the sample data that I considered:

Kishore_KVN_0-1692161386176.png

 

Your calculated measure looks as below:

Card Measure = 
Var a = MAX('Table'[Sales])
Var b = LOOKUPVALUE('Table'[Date],'Table'[Sales],a)
Return
"Maximum Sales are: "&a& UNICHAR(10)&"On: "&b

Output looks as below:

Kishore_KVN_1-1692161445159.png

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

 

I thought that @powerbiguy_  wanted value based on his hovering.
Now, I understand that he wants the maximum value and its date.
I deleted my suggestion

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
mickey64
Super User
Super User

I made some measures.

 

Step 1: I read the same data file 3 times , names of those datasheets are 'Sheet1', 'Sheet1+1', 'Sheet1-1' each.

 

Step 2: I added an index column in the 1st table 'Sheet1'.

mickey64_9-1692161299584.png

 

Step 3: I added an index column in the 2nd table 'Sheet1+1'.

mickey64_8-1692161000028.png

 

Step 4: I added an index column in the 3rd table 'Sheet1-1'.

mickey64_7-1692160959851.png

 

Step 5: I made 2 relationships.

mickey64_6-1692160850675.png

 

Step 6: I made some columns in 1st table 'Sheet1'.

mickey64_0-1692160613212.png

 

mickey64_1-1692160635971.png

 

mickey64_2-1692160667953.png

 

mickey64_3-1692160690688.png

 

mickey64_4-1692160708719.png

 

Step 7: I made a mesure.

M_Max Peak = MAX('Sheet1'[Peak Value]) 
mickey64_5-1692160772003.png

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.