Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear All,
I am trying to show running total of actuals till the selected month and forecast after the selected month in one line chart. Here is the file i am using:
Thank you in advance for the help.
Solved! Go to Solution.
Hi @adnanarain
Is this what you want? Download the attachment to see details. I add a Financial Month column in DimDate table and four new measures.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
@adnanarain , Try a measure like
var _max = maxx(allselected('Date'),'Date'[Date])
return
CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[Date]) && date[date] <=_max)) +
CALCULATE(SUM(forecast[forecast Amount]),filter(all(date),date[date] <=max(date[Date]) && date[date] >_max))
Common date table joined to you table and forecast and that is used on axis
@amitchandak Thanks Amit,
I have already tried this but this is not working. I need a year and month slicer with single value selection and based on month selection. If you can please download the file and you will get clear idea
Hi @adnanarain
Sorry I'm a little confused about the data table. In this table, there is a [Financial Date] column, [Month for Financial Date] and [Year for Financial Date]. Are the [Month for Financial Date] and [Year for Financial Date] columns identical with the [Fiscal Month] and [Fiscal Year] in DimDate table or are they just calendar month and year?
Do you look for a solution to get a similar output to the line chart in this blog?
Best Regards,
Community Support Team _ Jing
@v-jingzhang thanks for your reply. Financial month is the column to use. Ignore financial date
Hi @adnanarain
Is this what you want? Download the attachment to see details. I add a Financial Month column in DimDate table and four new measures.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |