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
aBerg
Helper II
Helper II

Slicer and dynamic X-axis w/ Column chart

Hi. 

 

I have a report with hour (hh:mm) granularity. This report has a column chart and three slicers (year, month and day). I need the column chart to be filtered and the axis X automatically adjust (dynamically) according to the selection of the slicers, as follows:

 

- when only year is selected in slicer, the X-axis must be the months
- when the year and month is selected in slicer, the X-axis must be the days
- and when the year, month and day is selected in slicer, the X-axis must be the hours (hh:mm)

 

SlicerXaxis.png

 

I could not find a way to do this with data slicers or filters. Could someone help me by showing me a way, please?

 

Greetings,

Berg

 

2 REPLIES 2
Anonymous
Not applicable

@aBerg -

Instead of using slicers, you could put all of those attributes on the axis and drill down.

Cheers!

Nathan

Hi @Anonymous 

 

Thanks for your feedback.

Ok, I understand your suggestion, however I would like to filter without the need to use the drill down/up buttons but change according to the selection of slicers.

 

Greetings,

Berg

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.