Forum Discussion

dicarva's avatar
dicarva
Frequent Visitor
1 year ago

Problem with Reference Line when trying to update filters

Hi there, I'm new to BI, and I would like to know, if there is a way to correct the problem with two references lines in graphic bars. I have two lines and when I click on the date to filter, in ...
General Comment
hnguy71's avatar
hnguy71
Icon for Super User rankSuper User
1 year ago

Hi dicarva 
Do you mind sharing your measures used? Typically if you select a date or a period and there are no values, the reference line should automatically go away. Perhaps you could add an additional criteria on top to force it to disappear.

dicarva's avatar
dicarva
Frequent Visitor
1 year ago

Thank you for answer.
I will share the graph and the measures for a better understand.
This is the correct graphc aspect:

 Then when I clicked in the filter this happens:

 
The first measure: 

MedidaByPass = CALCULATE(
        AVERAGEX(
            FILTER(
                CenariosIDE,
                CenariosIDE[Estado] = TRUE &&
                CenariosIDE[Descricao] = "CER Bypass"
            ),
            CenariosIDE[Valor]
        ),
        USERELATIONSHIP(CenariosIDE[Ano], Calendar[Ano])
    )

Another measure: 
MedidaMeta =
    CALCULATE(
        AVERAGEX(
            FILTER(
                CenariosIDE,
                CenariosIDE[Estado] = TRUE &&
                CenariosIDE[Descricao] = "Meta"
            ),
            CenariosIDE[Valor]
        ),
        USERELATIONSHIP(CenariosIDE[Ano], Calendar[Ano])
    )



I'm sorry because my Bi is in Portuguese.

I hope this can help you to understand.

  • hnguy71's avatar
    hnguy71
    Icon for Super User rankSuper User
    1 year ago

    Hi dicarva 

    Can you try this?

    MedidaMeta =

VAR _Result = 
    CALCULATE(
        AVERAGEX(
            FILTER(
                CenariosIDE,
                CenariosIDE[Estado] = TRUE &&
                CenariosIDE[Descricao] = "Meta"
            ),
            CenariosIDE[Valor]
        ),
        USERELATIONSHIP(CenariosIDE[Ano], Calendar[Ano])
    )

RETURN

If( _Result > 0, _Result, Blank() )
    • dicarva's avatar
      dicarva
      Frequent Visitor
      1 year ago

      No, it doesn't work.

      • hnguy71's avatar
        hnguy71
        Icon for Super User rankSuper User
        1 year ago

        Can you share a sample pbix ?