Reply
New Member
Posts: 1
Registered: ‎02-11-2019

Current year vs. Prior Year reporting

I am new to Power BI and am struggling with updating my dashboards with 2019. I have several visuals that were created last year that shows data comparisons for 2018 to 2017. Now that 2019 has started, I need to show the comparisons as 2019 to 2018. I loaded the 2019 data in and select it to show only 2018 and 2019 but none of the visuals are picking up the 2019 data. What am I doing wrong and how can I get Power BI to pull the 2019 data into my visuals.

 

 

 

Super User
Posts: 10,605
Registered: ‎07-11-2015

Re: Current year vs. Prior Year reporting

See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Community Support Team
Posts: 7,693
Registered: ‎05-02-2017

Re: Current year vs. Prior Year reporting

Hi @losoba,

 

Can you share the file if possible? You can only keep a few records to show the issue. Please mask the sensitive parts.

The possible cause is as follows.

1. The filters, such as the Page Level filter.
2. You hardcoded the year in the measures. 

3. Not enough dates in the Calendar table.

 

 

Best Regards,

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