I'm trying to compare different time periods with Power BI KPI visuals and for that reason created following measures:
Purchases = SUM('Purchases'[Quantity]) Previous Purchases := CALCULATE ( [Purchases], ALL ( 'Date' ), USERELATIONSHIP ( 'Date'[Date], 'Previous Date'[Date] ) )
For date table I'm using:
Date = VAR MinYear = YEAR ( MIN ( 'Purchases'[%DATE] ) ) - 1 VAR MaxYear = YEAR ( MAX ( 'Purchases'[%DATE] ) ) RETURN ADDCOLUMNS ( FILTER ( CALENDARAUTO ( ), YEAR ( [Date] ) >= MinYear && YEAR ( [Date] ) <= MaxYear ), "Year", YEAR ( [Date] ), "Quarter Number", INT ( FORMAT ( [Date], "q" ) ), "Quarter", "Q" & INT ( FORMAT ( [Date], "q" ) ), "Month Number", MONTH ( [Date] ), "Month", FORMAT ( [Date], "mmmm" ), "Month2", FORMAT ( [Date], "mmm" ), "Week Day Number", WEEKDAY ( [Date] ), "Week Day", FORMAT ( [Date], "dddd" ), "Year Month Number", YEAR ( [Date] ) * 100 + MONTH ( [Date] ), "Year Month", YEAR ( [Date] ) & " " & FORMAT ( [Date], "mmm" ), "Year Quarter Number", YEAR ( [Date] ) * 100 + INT ( FORMAT ( [Date], "q" ) ), "Year Quarter", "Q" & FORMAT ( [Date], "q" ) & "-" & YEAR ( [Date] ), "Year Month Day Number", (YEAR ( [Date] ) * 100 + MONTH ( [Date] )) * 100 + 01 )
I want to compare Purchases with Purchases Previous Period in KPI visual, using these attributes:
However, it seems that when I select more than one month in different year I only see data from the last years months, i.e. only 2022 Jan, 2022 Feb.
Any help would be appreciated, thanks!
Solved! Go to Solution.
Hi @Dom87326 ，
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.
Hello @aj1973 ,
I guess SAMEPERIODLASTYEAR would work if the KPI Value is correct. However in my case, values of KPI doesn't include 2021 Dec result of 147. Although when I use barchart it is included in the visual.
In the below example, filter is set on a page level and correct KPI value should be 553 instead of 386.
Hi again @aj1973 ,
Well, I've changed the initial measure to:
Purchases = VAR _YM = SELECTEDVALUE('Date'[Year Month]) VAR _CALC = CALCULATE (SUM('Purchases'[Quantity])), 'Date'[Year Month]) RETURN _CALC
However KPI still wouldn't return 2022 results.. Maybe I'm doing something wrong here?
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.