Dashboard

Hi Folks,

I have a data set, with columns like Metrics name, Date, Numerator, Denomintaor
Metrics Name= Text
Date=Date
Numerator/Denominator= Numbers ( Also contains Negative values)

So, we have to show Num divided by Den, group by Metrics name and bifurcated in Dates. So for an example, in Matrix visual, we will have Rows=Metrics Name
Column=Date
Values=Num/Deno
along with the additional columns
Current to Previous Month variance
Q1, Q2,Q..... depending upton what month is being selected in Date Slicer Visual
YTD
PY ( Previous Year)

Visual should be like this:
Metrics Name PreviousMonth  Current Month MonthVariance                         6 Month Trend Sparkline  Q1  Q2  YTD  PY
ABC                   223445               34567             (Curren-Previous)/Previous %
DEF                   212345               36879                 Same as above
GHI                   223564               34566                 Same as above

And Condition is:
Whatever month_year is selected on the Slicer, that month should be considerd as the current month hence all those numbers should change dynamically.
2. There should be no interm month over month variance for example, it should reflect as showed in the above structure. Reffering to quick measures.

Please help.

Thanks in advance.