Like

Welcome On Mobius

Mobius was created by professionnal coders and passionate people.

We made all the best only for you, to enjoy great features and design quality. Mobius was build in order to reach a pixel perfect layout.

Mobius includes exclusive features such as the Themeone Slider, Themeone Shorcode Generator and Mobius Grid Generator.

Our Skills

WordPress90%
Design/Graphics75%
HTML/CSS/jQuery100%
Support/Updates80%

Problems with Power BI – Fiscal Year Issue

By Usman Shaheen 4 months agoNo Comments

Problem

There are some problems with Power BI (See Business Intelligence) which include having an issue in displaying statistics in the report according to the fiscal year which I had set in the Timeline Slicer tool.

Let’s review in details of the problem by going through diagrams of Power BI report. The fiscal year set in the Timeline Slicer starts from 1st February.

                                Timeline Slicer                                                                   Chart

 

As you can see from the pictures I have selected Q1 of the year 2012 but the chart displays statistics of Q2 which is invalid.

Timeline Slicer Conjurations                                         

Timeline Slicer Conjurations

Solution

Let’s suppose the fiscal year of my organization is starting from 1 February and finishing on 31 January. As we all know that normal year starts from 1 January and ends on 31 December. So, In order to solve this problem, I added a new column manually and renamed it ‘fiscal months’. The above-mentioned example is pointing out that 1st month January in the normal year will be equal to the 1st month February of the fiscal year which is actually the 2nd month in the normal year. Considering this, in my new column of “fiscal months”, I adjusted this ratio and then I used the fiscal month column in my report with timeline slicer to fix this problem.

Read 6 signs you need a Business Intelligence solution

The following table shows the adjustment of the fiscal year start against the normal year according to the above-mentioned example:

S/N

Fiscal Year

Normal Year

1

February

January

2

March

February

3

April

March

4

May

April

5

June

May

6

July

June

7

August

July

8

September

August

9

October

September

10

November

October

11

December

November

12

January

December

The following diagrams show the correct data in the charts. No matter which quarter I select in the Timeline Slicer, the charts will show the correct statistics.

Now, after the Solution, I have selected Q1 of 2012 and as you can see from the diagram of the chart, it is not displaying any value. The reason is that Q1 does not have any record. Let’s see by selecting Q2 to check if solution is working fine or not.

Now, as you can see from the diagrams Q2 is selected in the timeline slicer and chart is also displaying Q2 which means our solution is working fine.

Timeline Slicer configurations with new column

Category:
  Business Intelligence
this post was shared 0 times
 000
About

 Usman Shaheen

  (7 articles)

Usman Shaheen is a Partner in Allied Consultants. With a decade of experience in integrating applications and organizations, he is one of the foremost authorities on Integration through Microsoft BizTalk server in the world.

Leave a Reply

Your email address will not be published.