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
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.
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)
Could you please share some sample data and clarify more details about your requirement?
Regards,
Jimmy Tao
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 | |
113 | |
105 | |
95 | |
58 |
User | Count |
---|---|
175 | |
147 | |
134 | |
105 | |
82 |