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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.