kpi card not adjusting value

[po]

Hi,

Have the following sales by day and calculate a media of this as

median_sales = round(MEDIAN(sales[sales_qty]),0) 

Have a slicer where can select the week and the above adjust correctly depdening on week selected.

Wish to have a kpi card visual which displays the value for the week selected but alwys shows the trend in background thus have set edit interactions to none when select the slicer.

Have tried 

sumX( FILTER(calendar,calendar[Week]=VALUES ( calendar[Week] )),<median_sales>)

However the value shown in kpi card visual is same regardless of what select in slicer i.e. 

How can we best have a kpi card visual where the value adjusts depending on week selected in slicer but the trend still remains vsible.?

Thanks

[v-lili6-msft]

hi, @po 

If calendar table has created the relationship with sales table like below:

and Kpi visual always show data of the latest date.

Also there are two similar post for you refer to:

https://community.powerbi.com/t5/Desktop/visual-KPI-week-previous-week/m-p/644979#M309098

https://community.powerbi.com/t5/Desktop/KPI-card-displays-different-value-to-card-and-table-any-way...

If not your case, please share your sample data and expected output.

Best Regards,

Lin

[po]

Hi,

Thanks for update.

Not quite what looking for in this scenario.

Looking to select slicer similar to below but want to snure the trend still remains visible when select individual slicer element but the value adjusts coresponding to the week selected - is this possible?

[v-lili6-msft · Accepted solution]

hi, @po 

What is your expected trend?

The trend is the visual is based on the result of the indicator value.

You could drag indicator and trend axis value in a line chart to test it.

Best Regards,

Lin

[po]

Hi,

Thanks for reply.