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

Max Value in a card

Hi All,

 

I just wanted to know, is there any way we can see the Max number of the People worked on any particular day based on the date on a card.

I have a Dax measure built in to calculate the people on the ground (Nothing but the Number of people working on any particular day)

 

I just wanted to have a card to see the only maximum number of people worked on any particular day when I have a large list of people.

 

I tried using the Multirow card.. which gives me all the numbers based on different dates. but I just wanted to see only the max number.

max.png

Regards,

Ranjan

1 ACCEPTED SOLUTION
v-robertq-msft
Community Support
Community Support

Hi, @RanjanThammaiah 

According to your description, you can try my method:

Click on this visual, go to Filter, place column [People on the ground] into the filter, then select TopN, and set like this:

v-robertq-msft_0-1606114047878.png

 

And you can get what you want.

You can download my test pbix file here

 

Best Regards,

Community Support Team _Robert Qin

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

View solution in original post

3 REPLIES 3
v-robertq-msft
Community Support
Community Support

Hi, @RanjanThammaiah 

According to your description, you can try my method:

Click on this visual, go to Filter, place column [People on the ground] into the filter, then select TopN, and set like this:

v-robertq-msft_0-1606114047878.png

 

And you can get what you want.

You can download my test pbix file here

 

Best Regards,

Community Support Team _Robert Qin

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

Anonymous
Not applicable

@amitchandak @RanjanThammaiah  You can drag value above date then it you can sort it by number .

amitchandak
Super User
Super User

@RanjanThammaiah , Try a measure like, do not put the date or you can use card visual

Maxx(values(Date[Date]),[people on ground])

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

Top Solution Authors