cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
po Member
Member

kpi card not adjusting value

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
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: kpi card not adjusting value

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

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Community Support Team
Community Support Team

Re: kpi card not adjusting value

hi, @po 

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

2.JPG

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

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
po Member
Member

Re: kpi card not adjusting value

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?

 

SCREENSHOT.JPG

Community Support Team
Community Support Team

Re: kpi card not adjusting value

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

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
po Member
Member

Re: kpi card not adjusting value

Hi,

 

Thanks for reply.