display date in min/max card visualization

[Raghda_Alshehhi]

Hi all, 

I've been searching for a measure to display the date also for my min/max card visualization. 

Can power bi support this?

E.g. I have daily sales since 2022 till now, and i have 2 cards showing the max/min sales in a given day. The card shows the max valu we reaced till today in sales, but i als need to add the date.

Is there a way to do so?

[ValtteriN · Accepted solution]

Hi,

Here is one way to do this:

1. Data: 

2. Dax:

Max Sales =

CALCULATE(max('MinMax KPI Sales'[Sales]),all('MinMax KPI Sales'))

Max Sales Date =

var _msales =

CALCULATE(max('MinMax KPI Sales'[Sales]),all('MinMax KPI Sales')) return

CALCULATE(max('MinMax KPI Sales'[Date]),ALL('MinMax KPI Sales'),'MinMax KPI Sales'[Sales]=_msales)

3. Place these values to e.g. Multirow card: 

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[v-yanjiang-msft]

Hi @Raghda_Alshehhi ,

Has your problem been solved? If so, would you mind accept the helpful replies as solutions?
If you have a given date period slicer, you can modify  @ValtteriN 's solution with allselected function intead of ALL.

Max Sales =
CALCULATE ( MAX ( 'Table'[Sales] ), ALLSELECTED ( 'Table' ) )

If you need further help, please feel free to let me know.

Best Regards,
Community Support Team _ kalyj

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

[Raghda_Alshehhi]

Hi kalyj,

Thank you for your response

Can you please explain this more 

[v-yanjiang-msft · Accepted solution]

Hi @Raghda_Alshehhi ,

According to your description, I create a sample. You can add date to the table everyday as you needed.

Now, create two measures.

Max = CALCULATE ( MAX ( 'Table'[Sales] ), ALLSELECTED ( 'Table' ) )

Min = CALCULATE ( MIN ( 'Table'[Sales] ), ALLSELECTED ( 'Table' ) )

Put the two measures in card visuals and according to the date slicer, they will change dynamically.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

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

[ValtteriN · Accepted solution]

Hi,

Here is one way to do this:

1. Data: 

2. Dax:

Max Sales =

CALCULATE(max('MinMax KPI Sales'[Sales]),all('MinMax KPI Sales'))

Max Sales Date =

var _msales =

CALCULATE(max('MinMax KPI Sales'[Sales]),all('MinMax KPI Sales')) return

CALCULATE(max('MinMax KPI Sales'[Date]),ALL('MinMax KPI Sales'),'MinMax KPI Sales'[Sales]=_msales)

3. Place these values to e.g. Multirow card: 

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/