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 August 31st. Request your voucher.
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.
Solved! Go to Solution.
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:
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:
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
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:
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:
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
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'.
Step 3: I added an index column in the 2nd table 'Sheet1+1'.
Step 4: I added an index column in the 3rd table 'Sheet1-1'.
Step 5: I made 2 relationships.
Step 6: I made some columns in 1st table 'Sheet1'.
Step 7: I made a mesure.
User | Count |
---|---|
80 | |
73 | |
39 | |
30 | |
28 |
User | Count |
---|---|
107 | |
99 | |
55 | |
49 | |
46 |