Power BI Archives - Caldere Associates

Years 2000 and 2500 Incorrectly Shown in Power BI Report

By | Act!, Power BI, Support, Tips and Tricks | No Comments
By Meeta Gargav

We came across an unusual situation in which incorrect years (2000 and 2500) were shown in the X-axis of a Power BI report. Our questions about this issue weren’t specifically answered no matter how much Internet searching we did. We did find a workaround, and we’re describing it in this blog post in the hope that it saves someone else tearing their hair out!

Incorrect Years 2000 and 2500

We created a Power BI report using data from the Act! Opportunity module. This simple report shows the count of opportunities won (Y-axis) over the time period (X-axis).  The slicer in this report is the actual close year.  The report works as expected when we select multiple years.

year 2500 glitch (1)

However, we noticed issues with the report when we selected only a single year. Instead of the selected year (2015 in the example), the X-axis displayed the year 2000, which we did not select, even though it displayed the appropriate data for 2015. It also added 2500, a year that did not correspond with any data, and that did not even appear in the list.

Showing 2500 in X-axis

We get quite a few hits when we run a search on power bi displaying the wrong year.  Some of them are listed at the end of the post, but my workaround is different from the recommendations I found on Google.

Our Workaround

When the issue is present and we select X-Axis in the Format section, we notice the Type drop-down is set to Continuous. Type allows us to choose either Continuous or Categorical.

Most of the resources I found on the Internet say that in a report like ours, the Year should be set to Continuous and the Scale Type to Linear. I found that this setting didn’t work in the case at issue. But when we change Type to Categorical, the report appears as we expect.

Wrong Year Issue Corrected

Here’s a closeup of the corrected report:

Corrected report

The other workaround that I have found is to create another Year column and make it a text field. We would then use the decimal Year for the slicer, and the text Year for the X-axis. However, the reason I don’t use this as my default is that we would then be bulking up our Power BI report with extra columns.

I am really interested in what you think of my workaround, so please leave a comment.

View a YouTube demonstration of the issue and workaround by clicking this link!


Here are a few of the search results that I examined:

https://community.powerbi.com/t5/Desktop/shows-wrong-year/td-p/27652
https://www.mrexcel.com/forum/power-bi/894525-correct-date-wrong-display-powerbi.html
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-data-types/

Great Power BI Updates for the New Year!

By | Power BI | No Comments

Just before the new year Microsoft made some great Power BI updates, especially to their Power BI mobile apps. These new updates include:

  • New capability to share an annotated report by adding inking, text or symbols to a snapshot of any dashboard tile. This update has improved the menu and user experience to make it even easier and quicker to annotate and share. We can add a call to action on a specific metric and share the annotated snapshot over email, text or any other social apps. In addition, when we share a snapshot via email, Power BI will also generate a deep link to the tile or report. For example, Act! users viewing their closed-lost opportunities will be able to make annotations on the diagram.
  • Geofiltering for reports on Android devices.
    Earlier this year Power BI introduced the ability to filter reports based on the user’s current location for the iOS app. Now we can also use our Android device to filter reports by our current location. When using this app, we can filter our data by our country, state or city. As long as we are using the app, the filter will remain in effect in the reports to which we applied it. Act! users will now be able to section their Act! contact list data within Power BI.
  • Improvements to existing features:
    • Visual Links
    • Apple Watch integration
    • Offline background refresh adjustment to reduce mobile data consumption.

These new Power BI updates allow us to make sure our dashboards are always up to date, just by marking them as favorites.

How Can We Help?

Find out how Caldere can help you to build a more successful business:
Call +44 (0)118 945 6220 and speak to one of our dedicated specialists.

Contact us!