Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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
Solved! Go to Solution.
@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))
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
@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))
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
75 | |
63 | |
51 | |
48 |
User | Count |
---|---|
211 | |
86 | |
64 | |
59 | |
56 |