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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

Display site name of max figure

Hi, 

I am in the process of self teaching in Power BI so this is a very basic question but I can't find a video or question on it on here. I have my data input to Power Bi and I have a card on my dashboard of the max reading (Its CO2 monitoring readings) but I cant work out how to display on the card which is the site with the highest reading? 

Any help is much appreciated. 

 

Calb123_0-1674737725918.png

 

1 REPLY 1
m_alireza
Solution Specialist
Solution Specialist

Hi @Anonymous 

Is this what you are looking for?

Create a new measure as below:

 

 

Site Name Max Reading = CALCULATE(MAX(CO2 Monitoring[Site:]),CO2 Monitoring[Readings - PPM (Parts Per Million)]=MAX(CO2 Monitoring[Readings - PPM (Parts Per Million)]))

 

 


Place Measure in your card visual instead of what you have now

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.