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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
szrirem
Regular Visitor

showing max value and label on card

Hello everyone,

 

I am trying to show max value and max value label on card. I did a visualization like below. 

 

tree map.PNG

I want to print the maximum number of 541 in this visualization and its label on card. I wrote a formula like below to get 541. But the label is wrong.

 

Measure =
 MAXX(
    KEEPFILTERS(VALUES('Yol Izin Belge Sayisi'[Belgeyi Veren Birim])),
    CALCULATE([Toplam Yol İzin Belgesi Alan Kişi Sayısı])
)
number.PNG
 
 
 
 
 
with these code I calculated 542 but I couldnt display true label. The label has to be Mersin 
 
How can I do this ?
 
Thank you in advance 
2 REPLIES 2
Arul
Super User
Super User

@szrirem ,

modify and try this measure based on you data,

Max sales by segment = 
VAR _maxX = MAXX(
    VALUES(financials[Segment]),
    CALCULATE([Sum of Sales]))
VAR _tempTable = 
SUMMARIZE(
    financials,
    financials[Segment],"@Sales",SUM(financials[ Sales])
)
VAR _result =  CALCULATE(
    SELECTEDVALUE(financials[Segment]),FILTER(_tempTable,[@Sales] = _maxX))
RETURN _result

Thanks,

Arul





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


Idrissshatila
Super User
Super User

Hello @szrirem ,

 

Try adding the measure you made along with the dimension you're using in a multi-row card.

 

Idrissshatila_0-1676983431489.png

 

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍

Follow me on Linkedin



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.