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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.