Forum Discussion

bi_trax87's avatar
bi_trax87
Frequent Visitor
2 years ago
Solved

Field Parameters with Measures, Variance Analysis

Hi,

 

I would like to know if it is possible to select a measure from a field parameter and besides changing the line chart to the selected measure values to also alter the difference chart (with the same slicer)

 

If I use the field parameter in the difference chart it would only have the absolute measure and not the YoY that should be displayed in the difference chart

 

 

Any thoughts?

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi bi_trax87 

    If your measure parameters are all comparative, such as selecting both this year and last year, you may want to consider creating a measure and subtracting either this year or last year from the parameters, you can refer to the following sample.

    Sample measures.

    The paramater order.

    Create a measure, then put the measure to the column chart visual

    MEASURE =
IF (
    ISFILTERED ( Parameter[Parameter Fields] ),
    SWITCH (
        TRUE (),
        MAX ( Parameter[Parameter Order] ) IN { 0, 1 }, [TotalSales] - [TotalSalesLY],
        MAX ( Parameter[Parameter Order] ) IN { 2, 3 }, [TotalSales34] - [TotalSales34LY]
    )
)

    Output

     

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi bi_trax87 

    If your measure parameters are all comparative, such as selecting both this year and last year, you may want to consider creating a measure and subtracting either this year or last year from the parameters, you can refer to the following sample.

    Sample measures.

    The paramater order.

    Create a measure, then put the measure to the column chart visual

    MEASURE =
IF (
    ISFILTERED ( Parameter[Parameter Fields] ),
    SWITCH (
        TRUE (),
        MAX ( Parameter[Parameter Order] ) IN { 0, 1 }, [TotalSales] - [TotalSalesLY],
        MAX ( Parameter[Parameter Order] ) IN { 2, 3 }, [TotalSales34] - [TotalSales34LY]
    )
)

    Output

     

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • bi_trax87's avatar
      bi_trax87
      Frequent Visitor
      2 years ago

      Thanks a million!

       

      I believe UX wise it is not ideal to select what you want in pairs (i.e. Current Year & Previous Year)

       

      However in a scenario where you have Current Year vs Budget/Forecast/Target where Current year is always the same and you compare vs a field parameter this would be amazing

       

      Thanks again