Display values of a filter in a bar chart

[Anonymous]

I have a bar chart that consists of two measures and dimenssão which is the year, I need this chart to have some year filtered view beyond the filtered value from previous years, for example 2014 filter: will display the values of 2014 2013 2012 ........, an example of a chart made in QlikView is below, and the measures used too.

measures:

Not processed = sum (Facts [Vl_RestoNa processed])

Processor = no (Facts [Vl_RestoProcessado])

[BhaveshPatel]

YOU CAN USE THIS FORMULA

PY SALES=CALCULATE([Total Sales],DATEADD(DimDate[Datekey],-1,YEAR))

[TOTAL SALES] = SUM([SALES AMOUNT])

CHANGE THE -1 PART AS PER WHAT AMOUNT WOULD YOU LIKE.

IF YOU LIKE LAST 2 YEARS, CHANGE IT TO -2. 

YOU NEED A RELATIONSHIP WITH DATE TABLE TO CREATE A TIME INTELLIGENCE CALCULATIONS.

[Anonymous]

@BhaveshPatel

I created the expression as indicated however failed.

the graph showed no value, I applied the new expression with dimenssão year, is that right?

Remains processed = CALCULATE ([processed]; DATEADD (DMEGF_Ano [Year] - 1, YEAR))

[v-sihou-msft]

@Anonymous

In Power BI, we can't add condition based on current selection in slicer to control the rendering records in visuals. For your requirement, I suggest you use custom visual like Timeline to select date range to display data. You can download it from: https://app.powerbi.com/visuals/

Regards,