Field Parameters with Measures, Variance Analysis

[bi_trax87]

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?

[Anonymous · Accepted solution]

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]

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