cancel
Showing results for
Did you mean:
Helper II

## Year long revenue line chart simultaneously with a specific month sliced the matrix visual

Hello

I'm a newbie and am really stuck.

I'm displaying an income statement sliced by two months using the chiclet slicer.

On the same page I need to display a line chart of the actual revenue (line "Ingresos Brutos" which is the result of a running total measure) and the budgeted revenue (line "Facturacion" based on data from the 'Budget' table) for the last 12 months counting from the last date of data in the 'Actual' table data.   Following the same logic I need to display the net results ('Resultado Neto').

I can't get the chart up and running

1 ACCEPTED SOLUTION
Super User

@JuanBolas , If you select one date and want a trend of more than 1 month, then you need slicer on independent date table

//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = eomonth(_max, -12) +1
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

2 REPLIES 2
Helper II

Thank you @amitchandak!

Super User

@JuanBolas , If you select one date and want a trend of more than 1 month, then you need slicer on independent date table

//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = eomonth(_max, -12) +1
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

Announcements

#### Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

#### Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

#### Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors