Forum Discussion

ArchStanton's avatar
ArchStanton
Power Participant
2 years ago

KPI Reporting

Hi, I have a report that is connected to live data to which I have recently added 12 new KPIs. These KPI's are being presented in mixture of Cards and Matrix tables.   As this is the first month ...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi ArchStanton 

 

In Power BI, KPI trends can be tracked over time without having to manually create metrics for each month.

 

Create metrics to calculate KPIs for the current month, previous months, and any other time period you are interested in.

 

Use these dynamic measures in line graphs.

 

For line charts, you can set the x-axis to the month column in the date table and the y-axis to the dynamic measure. This will give you a 12-month trend.

 

Here I have provided a simple example.

 

Here's some dummy data

 

“Table”

 

Create a measure.

 

Measure = 
var _month = MONTH(SELECTEDVALUE('Table'[Date]))
return
CALCULATE(SUM('Table'[values]), FILTER(ALL('Table'), MONTH('Table'[Date]) =_month))

 

Here is the result.

 

 

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

ArchStanton's avatar
ArchStanton
Power Participant
2 years ago

I would like the measure to count all items that are over 3yrs old now and then show what that total would have been in 2021, 2022 and 2023.

 

# Cases 3 Yrs or Older = 
    CALCULATE(
        COUNTROWS(FILTER('Cases',
        'Cases'[Case Length] > 1095)),
        'Cases'[statecode] = "Active")

 

This gives me the current total, 1095 is the number of days in 3yrs. 

 

I have a Created On date thats linked to my 'Date2'.[Date] calendar table.

Is this possible do you think?