Forum Discussion
Add Quarterly target to KPI chart
Hi,
I need to get a KPI chart with Quartely target with start and end value.I have attached an image to show what i exactly need.I have start and end value in my target table.
Can someone help me to get this chart like this? Actual line also there.Target line should continouly show quartely with start and end value.
Thanks
4 Replies
- amitchandak
Super User
Anonymous , On the same line if you want to have the value you need to have value both on start and end date.
That need how is you data available.
One way I can think off is join qtr start date and end date with date table. One join will inactive.
Now create a formula
Sum(Target[value]) + calculate(Sum(Target[value]), userelationship(Date[Date], Target[qtr end date])) //Assumed inactive is end date.
How get these start and end date. You can check my calendar blog or video or target
First few min of this video : https://www.youtube.com/watch?v=yPQ9UV37LOU
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
Hi amitchandak
I have already connect target and date table via date key.I want to make a measure to show start value and end value in same line quartely.Thats my requirement.
Thanks
- amitchandak
Anonymous , Sample data would help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
