Forum Discussion

amalrio's avatar
amalrio
Icon for Helper V rankHelper V
5 years ago
Solved

filter a graph visual by a measure

Hi Gurus,    I have a requirement to filer a graph visual by a measure, filter need to be at the visual level of the graph, and measure is a selected value coming from the report pane.   How do I...
data protection
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi amalrio ,

    What's your expected result? Which field of the table the slicer year plan is from? That is a default field in table or a a calculated column? If it is a calculated column, please provide the related formula. It will only display the data marked with red circle in table visual when select the option "2020 5 Year Plan" in the slicer?

    In addition, please update the formula of your measure [Measured in Plan] as below(the part with red font is new added) and check whether it can get your expected result:

    Measured in Plan =
    VAR Inferred = [Inferred in Plan]
    VAR Indicated = [Indicated in Plan]
    VAR Total = 1 - Inferred - Indicated
    VAR Result =
        DIVIDE (
            IF (
                Total = 0
                    || ISBLANK ( Indicated )
                    || ISBLANK ( Indicated ),
                BLANK (),
                Total
            ),
            1
        )
    RETURN
        Result

    Best Regards

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi amalrio ,

What's your expected result? Which field of the table the slicer year plan is from? That is a default field in table or a a calculated column? If it is a calculated column, please provide the related formula. It will only display the data marked with red circle in table visual when select the option "2020 5 Year Plan" in the slicer?

In addition, please update the formula of your measure [Measured in Plan] as below(the part with red font is new added) and check whether it can get your expected result:

Measured in Plan =
VAR Inferred = [Inferred in Plan]
VAR Indicated = [Indicated in Plan]
VAR Total = 1 - Inferred - Indicated
VAR Result =
    DIVIDE (
        IF (
            Total = 0
                || ISBLANK ( Indicated )
                || ISBLANK ( Indicated ),
            BLANK (),
            Total
        ),
        1
    )
RETURN
    Result

Best Regards

amalrio's avatar
amalrio
Icon for Helper V rankHelper V
5 years ago

Thanks a lot Rena, when I check is blank my issues get sorted, my issue was when Infrred and indicated are blank Measured in Plan  should not show either.