Max Value in a card

[RanjanThammaiah]

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.

Regards,

Ranjan

[v-robertq-msft · Accepted solution]

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:

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]

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

[amitchandak]

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

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