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
Anonymous
Not applicable

A slicer to choose the X-axis of my plot ?

Hi,

 

I want to vizualize sales (from 2010 to 2020). I need 2 options :

- define the period : if i choose year, i will have 11 curves (2010, 2011,...), if i choose trimester, 42 (from 2010 T1 until 2020 T2), etc

- define the x axis : by trimester, by month, by week, by day

 

If i choose a "trimester" for period and "week" for x-axis, then i will have a x-axis from 1 to 13 (because you have 13 weeks in a trimester), so a simple date hierarchy cant solve all the problem.

 

I know how to use slicer to make a filter, but I dont have a solution to select the "period" or the "x axis" ?

 

Last information : all my data is in the same table.

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , Did not get it completely.

But if you want to change axis you need bookmark -https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

If you want to change measure, you can do like -https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115

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.