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 Experts,
I have a KPI model data imported from tabular
only last day of each month has KPI value.
this is my data relationship map
my unique key is date&servicenumber(combined)
my goal is to use kpi indicator or other kpi visualization to show monthly actual kpi against kpi target.
for instance, i have a reliability KPI v actual reliability
my reliability% actual measure is = ([First Departure]-[Services Cancelled])/[First Departure] (all data is from daily services)
I've tried import kpi wookbook into power bi, but didn't work, due to i set date range is always in the previous 365 days.
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-import-and-display-kpis
I've also tried this method, didn't work, see in the screenshot, both table date format is the same dd/mm/yyyy
https://community.powerbi.com/t5/Desktop/Convert-monthly-data-to-daily/td-p/764130
then my final table
it looks my daily services operating date only shows the last day of each month
Would appreciate if anyone can help me on this.
here's my pbix file to test.
https://1drv.ms/u/s!AjpB2wk5YDY3hwcMerV8tWakwlVY?e=rh8Kjz
Solved! Go to Solution.
@Yiling , if you have monthly value, You can get that at the day level
new measure
KPi Value =CLOSINGBALANCEMONTH(Sum(Table[Value]),Date[Date]) //same value will repeat each day
KPi ValueDaily = Divide([KPi Value],day(eomonth(Date[Date],0)))
or
KPi ValueDaily = Divide([KPi Value],day(eomonth(max(Date[Date]),0)))
Also refer: https://community.powerbi.com/t5/Community-Blog/Distributing-Allocating-the-Yearly-Target-Convert-to...
https://www.youtube.com/watch?v=yPQ9UV37LOU
@Yiling , if you have monthly value, You can get that at the day level
new measure
KPi Value =CLOSINGBALANCEMONTH(Sum(Table[Value]),Date[Date]) //same value will repeat each day
KPi ValueDaily = Divide([KPi Value],day(eomonth(Date[Date],0)))
or
KPi ValueDaily = Divide([KPi Value],day(eomonth(max(Date[Date]),0)))
Also refer: https://community.powerbi.com/t5/Community-Blog/Distributing-Allocating-the-Yearly-Target-Convert-to...
https://www.youtube.com/watch?v=yPQ9UV37LOU
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 |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |