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
ashaykohad
Helper I
Helper I

Need to change Month Values to Year Values in X axis

I have 2 tables
Table 1 : vehicledata
vehicle_number          invoice amount         date

Tabel 2 : calendardate

 

date        month      year      quarter       fyquarter       monthnumber

I have created one slicer for the year from calenderdate.

My query is when no slicer year selected (means all years data), I need chart axis as year wise.

and if any one year is selected in slicer, i need chart axis as month wise.

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

AFAIK this it not currently supported in the product.

One possible way to solve this would be to use buttons for the years instead of a slicer.

Then create two visuals - one with year on the axis and one with month.

Then create multiple bookmarks - one that only shows the year chart and others that only show the monthly chart filtered to the particular years and use actions to simulate what you're trying to achieve.

Granted this isn't very scalable as you'd have to keep adding buttons every year but it's the only way I know to implement what you want in Power BI.

You can do what you want in paginated reports if you have access to Premium.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

AFAIK this it not currently supported in the product.

One possible way to solve this would be to use buttons for the years instead of a slicer.

Then create two visuals - one with year on the axis and one with month.

Then create multiple bookmarks - one that only shows the year chart and others that only show the monthly chart filtered to the particular years and use actions to simulate what you're trying to achieve.

Granted this isn't very scalable as you'd have to keep adding buttons every year but it's the only way I know to implement what you want in Power BI.

You can do what you want in paginated reports if you have access to Premium.

Anonymous
Not applicable

Hi,

 

You need to create calculated columns for Year and Month.

- I hope it helps. 

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.