Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Iyke4joe
Frequent Visitor

YOY Analysis with Default Year on Dashboard

I have a table that includes the following column and measures

 

EventDate Column  from Table(Events) from 01/01/2010 – 12/31/2016

SR_PrevYr = CALCULATE([Sig_Rate],SAMEPERIODLASTYEAR(EventDate[Date]))

SR-PY_Variance(%) = CALCULATE(([Sig_Rate] - SR_PrevYr]) / SR_PrevYr])

 

I created a Date Dimension as

MyDate = CALENDAR(MIN(Table[EventDate]), MAX((Event[EventDate])))

 

I need to create a YOY Analysis and have my dashboard set at a default date of 2011 and then show this on a filled map and any other appropriate visual.

 

Please help with the best way to approach this. I have tried some ways I know but kept getting errors and blanks.

 

 

 

2 REPLIES 2
Iyke4joe
Frequent Visitor

@v-yuta-msft 

I have a KPI showing IncreaseRates (in percentage) for every year and another Column showing Regions ( North, West, East and South)

 

I have this column with dates (below) and I want to be able to slice the KPI vs the Regions such that, the final dashboard is defaulted to 2016 values everytime the dashboard is reopened.

 

Dates = 1/1/2010 to 12/31/2016 (to be used for slicer)

Iyke4joe_0-1593030777151.png  

 

 

v-yuta-msft
Community Support
Community Support

@Iyke4joe ,

 

Could you please share some sample data and clarify more details about your requirement?

 

Regards,

Jimmy Tao

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.