Forum Discussion

PBNikr's avatar
PBNikr
Icon for Helper I rankHelper I
7 years ago

Hiding missing values in a line chart (direct query)

 

I would like to hide certain values in a line chart. Is there any way to do this?

 

As you can see in the line chart below there are values missing for "Value" and these disappear when "Average" is removed from the chart. We would however like to keep "Average" in the chart and just hide the missing values for "Value" somehow.

 

Can this be done?

 

Need Help

3 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi PBNikr

    Could you show some data for better analysis?

    Such as the columns in the X-Axis, Value field, legend field?

     

    Best Regard

    Maggie

    • PBNikr's avatar
      PBNikr
      Icon for Helper I rankHelper I
      7 years ago

      Hi v-juanli-msft!

       

      I have attached a table with sample data:

       

       

      As you can see, the gaps in data occur on weekends. I am connected to a model using Direct Query and am therefore limited to what I can alter directly in Power BI. 

      • v-juanli-msft's avatar
        v-juanli-msft
        Icon for Community Support rankCommunity Support
        7 years ago

        Hi PBNikr

        It seems you face the similar problem like line chart not representing null values, you could create a measure to replace "Value" .

        Measure = IF(MAX([value])=BLANK(),0,MAX([value]))

         

        Best Regards

        Maggie