cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Route217
Post Prodigy
Post Prodigy

Bar Graph not showing all the Month for the Year

Hi Expert

 

Having a nightmare of a day over a simple task. I am trying to plot bar chart showing all the values as per my measure for all the periods in the year, but the graph is only returning back Jan 21. i want to see all the month in the year. 

 

May be the issue is that i make the measure indepandant of the Select Period Slicer and work for all the other Slicers.

 

Link to Sample file

https://www.dropbox.com/s/arxz602yy9b3yx0/Garphs_.pbix?dl=0 

 

Image to Show how i have filter the FACT table to get the correct result for period JAN (Sense Check)

Capture.PNG

1 ACCEPTED SOLUTION
VijayP
Super User I
Super User I

@Route217 

Frankly it is related to Data Modelling issue ! Also your Data doesnt contain a Date which is a must for such dataset

- First Remove All columns other than months in the PL Table.
-  Create a Column Containing a Date ( may be a start of the month or End of the month any one is fine)
- Create a Date Dimension and connect the same to the Fact Table

- Then create measure using the DAte Table 

Let me know if you could achieve the goal as required




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


View solution in original post

5 REPLIES 5
VijayP
Super User I
Super User I

@Route217 

Create a new column in PL_2 with this formula  

Date = 1&PL_2[Month]&PL_2[C_Year]
Change the Data type to Date in Powe Query Editor ( you need to use Transform  Data option in Home Tab to get into power query editor) and select the Pl_2 Table and change the Date column to Date.
Create a Date Dim using 
DateDim = CalendarAuto()
Your measure should be accordingly evaluated using Date Dim 
and then you can acheive.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


Hi I am not seeing the Calculated column in Power Query in order to complete the step

Hi Vijay

 

Not working sorry to be a pain...

VijayP
Super User I
Super User I

@Route217 

Frankly it is related to Data Modelling issue ! Also your Data doesnt contain a Date which is a must for such dataset

- First Remove All columns other than months in the PL Table.
-  Create a Column Containing a Date ( may be a start of the month or End of the month any one is fine)
- Create a Date Dimension and connect the same to the Fact Table

- Then create measure using the DAte Table 

Let me know if you could achieve the goal as required




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


View solution in original post

Hi Vijay

 

The Data comes from the PL_2 Table...Apologies for any confusion.... Could you assist in completing the solution??

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.