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 t...
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.

     

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