The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
We would like a KPI visual that shows the percentage change over the current year, combined with the trend month by month.
With the standard KPI visual, you always see the latest change% when you add a trend ...So when you show the trend by month in the current KPI Visual, the kpi value shown is the change over the current month. We would like to see the overall YTD change% (from 1/1 until today) as KPI value and in the trend the monthly change% (so for each month the change from the first day until the last day of that month)
remark : a YTD calculation will not work because we have daily data that can not be added up (for ex daily inventory levels)
I suppose we will need the KPI value independant from the datetime-category used in the trend
Any idea if this already exists ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.