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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
kevderbeste
Helper III
Helper III

X Axis show since january every year to today

Hi everyone, I need to put my sales metrics in a evolutive linear graph, always showing since january actual year to actual month, how can put this in my x axis ? 

2 REPLIES 2
amitchandak
Super User
Super User

The information you have provided is not making the problem clear to me. Can you please explain with an example. If possible please share a sample pbix file after removing sensitive information.
Thanks

Hi, thanks for reply. 

 

I have sales as a metric, and i have DateSales as a date dimension, i want to put the information in a evolutive lineal graph, but I need the first month always be current year's january and the last month in th x axis be the max(DateSales) filter.

 

I need the graphic does not respond to the start date, instead, I need the first date to be January of the current year.

 

Here my example file https://1drv.ms/u/s!AtEkAF7ffIsqg8N89RJCFwca0oghUA?e=L0nVWN

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.