Chart Formatting

[Anonymous]

I have the below chart. There will be a trigger on the page that shows the max 2 months. What I would like to do is show the lattest two months but also show for my % dimension the last three months. So for example. the line graph would show the % for month 201706,201707 & 201708. (Visually I think that looks better)

The requestor would like to be able to filter on month when needed.

Like below but only showing two months and not three.

[Anil_Babu_Samineni]

Like this?

[Anonymous]

Yes and I can still use the Month slicer? If so, can you attached the sample app?

[sunny_talwar]

Try this

Num(Count({<STATUS = {"1"} >} ID)/

Above(Count({<STATUS= {"1"}, MONTH>} ID), 1) - 1, '#.00%')