Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
@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
Hi @Anonymous ,
If you both have start value and end value, I would recommend to use line chart to show the trend more directly, a KPI chart would not show the date axis.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , Sample data would help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |