Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Have the following sales by day and calculate a media of this as
median_sales = round(MEDIAN(sales[sales_qty]),0)
Solved! Go to 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
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
If not your case, please share your sample data and expected output.
Best Regards,
Lin
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?
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
Hi,
Thanks for reply.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |