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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
MarcoMizz
Frequent Visitor

clustered column chart how to display only the actual current months

Hi Everyone, 

I would like to know if it is possibile to display in the clustered column chart only the current monts of the year, so for example suppore the current month is march 2023 in the chart I would like to see, automatically, only the column bar related to january february and march on X-axis. then in april the column bar will be added automatically.

I hope my request is understandble 🙂

Regards

marco

 

Immagine.png

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@MarcoMizz , if there is no filter on date, this will give YTD trend

 


new measure =
var _max = today()
var _min = eomonth(_max, -1*month(_max) ) +1
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
MarcoMizz
Frequent Visitor

Hi Amitchandak 

your DAX formula fuction very well, I just modify a little bit, because I need to have the difference between budget value and actual value, see below the coding

 

thanks a lot fo the help

 

marco

 

Test New measure =
var _max = today()
var _min = eomonth(_max, -1*month(_max) ) +1
return
calculate( (sum(fFLXScritture[Actual]) - SUM('fMBCR_Budget'[BUDGET])), filter('Calendar', 'Calendar'[Date] >=_min && 'Calendar'[Date] <=_max))


amitchandak
Super User
Super User

@MarcoMizz , if there is no filter on date, this will give YTD trend

 


new measure =
var _max = today()
var _min = eomonth(_max, -1*month(_max) ) +1
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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