Problem with Reference Line when trying to update filters

Question

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 a year that doesn't have any values, one reference disappears (which is okay) and the other one goes to the bottom, and this one should also disappear. For each line I have measures.Is this a BI problem or am I so dumb?Thank you! 🙂

hnguy71 · Answer

Hi&nbsp;dicarva&nbsp;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.

ritaf1983 · Answer

Hi&nbsp;dicarva&nbsp;
Please provide a workable sample data and your expected result from that. It is hard to figure out what you want to achieve from the description alone.&nbsp;&nbsp;
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
&nbsp;

dicarva · Answer

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:&nbsp;The first measure:&nbsp;MedidaByPass = CALCULATE(&nbsp; &nbsp; &nbsp; &nbsp; AVERAGEX(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CenariosIDE,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CenariosIDE[Estado] = TRUE &amp;&amp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CenariosIDE[Descricao] = "CER Bypass"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CenariosIDE[Valor]&nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; USERELATIONSHIP(CenariosIDE[Ano], Calendar[Ano])&nbsp; &nbsp; )Another measure:&nbsp;MedidaMeta =&nbsp; &nbsp; CALCULATE(&nbsp; &nbsp; &nbsp; &nbsp; AVERAGEX(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CenariosIDE,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CenariosIDE[Estado] = TRUE &amp;&amp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CenariosIDE[Descricao] = "Meta"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CenariosIDE[Valor]&nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; USERELATIONSHIP(CenariosIDE[Ano], Calendar[Ano])&nbsp; &nbsp; )I'm sorry because my Bi is in Portuguese.I hope this can help you to understand.

hnguy71 · Answer

Hi&nbsp;dicarva&nbsp;Can you try this?MedidaMeta =

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

RETURN

If( _Result &gt; 0, _Result, Blank() )

dicarva · Answer

No, it doesn't work.

Forum Discussion

Problem with Reference Line when trying to update filters

6 Replies

Related content

FILTERING PROBLEM

Filter problems

LastDate filter problem

Problem with filters in Power Bi service

Cross filtering problems