Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
sunilege
Frequent Visitor

Bar chart shows all the months together. Am looking for Year+Month bifurcation

I have data as below..

 

ATTEMPT DATENo
20-Jul-171
23-Jul-171
2-Aug-181
3-Aug-181
18-Aug-171
2-Sep-171
29-Jul-181
28-Aug-171
1-Aug-171
31-Aug-171

 

When tried to plot a bar chart all the months are clubbed together, as below..

 

Capture.JPG

 

Am looking for variation in Year + Months combo. like below..

 

op needed.jpg

 

Simple but am struck in exploring. Please help and also I need the X-Axis in  Year+Month sorting. Normally its been arranged as Characeter

 

1 ACCEPTED SOLUTION

Hi @sunilege,

Could you please check if you have checked the 'Show dates as a hierarchy' option in your Power BI Desktop?

1.PNG

Regards,

Daniel He

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

View solution in original post

8 REPLIES 8
v-danhe-msft
Employee
Employee

Hi @sunilege,

Based on my test, you could choose the Year and Month filed in the date hierarchy:

1.PNG

 

You could also download the pbix file to have a view.

 

Regards,

Daniel He

 

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

Hi,

 

@v-danhe-msft Any further information, Please let me know am struck its making me crazy...

Hi @sunilege,

Could you please check if you have checked the 'Show dates as a hierarchy' option in your Power BI Desktop?

1.PNG

Regards,

Daniel He

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

Hey got it. It affected now.

 

Thankyou!!

@v-danhe-msft  You can see my 3rd post what I was explaining in the eariler one.

Yes, This I have enabled but still there no improvement. 

 

In your pbix file the graph name itself is "Count of No by Year and Month". Can you remove/uncheck the Month or/and year field and re-include it/them and try.

 

When we re-incude it/them this is losing the functionality.

Only options avialable now are..

1. "Count of No by Year "

2. "Count of No by Month"

 

But not  "Count of No by Year and Month" .

Hi,

 

The thing am not able find the hirearchy in field pane . Please see below..

 

Step 1: The same pbix file

1.JPG

 

Step 2: Unchecked the date field from field pane

2.JPG

Step 3:  Checked the date field. No hirerachy seen in field pane but Iam able to hirerachy in vizualiation pane I have removed Qtr and Day and retained Year and Month but that is not helping see below..

3.JPG

Hi Daniel,

 

Thankyou!!

 

When I tried to edit the hirerarchy and again choosed year month it not arriving again as desired. Why this could be ?

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors