Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Constant Line loses its format

Hi, I'm using a constant line that is dynamically calculated to represent the average state performance across all entities. As per the screenshot below, the measure uses a custom format to display ...
General Comment
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Thanks for your help on this. I eventually opted for displaying the constant line when the Countrows(HubTable) > 0.  

vanessafvg's avatar
vanessafvg
Community Champion
4 years ago

can you not filter the blank  section out? its actually really hard to answer this question with the limited information you have given, i do not know how your data is modelled, i also do not know what your objective with the data is.   If you need a more detailed response you will need to give more information like

what your data looks like the sample data ie the model and a sample to understand why it is being displayed if no data is showing

what requirement you are trying to solve

assuming you are using the y axis constant line?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Here is a link to a sample model that replicates the bug.

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    4 years ago

    Hi, Anonymous 

    Please add another table as below:

    DivisionName = DISTINCT('Hub Table'[DivisionName])

    Then use the field 'DivisionName' in this new table to replace your previous field to filter the data in your visuals.

    Result:

     

    Best Regards,
    Community Support Team _ Eason

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks for your help on this. I eventually opted for displaying the constant line when the Countrows(HubTable) > 0.  

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    4 years ago

    I have played around with your data a bit but I don't think it is possible to remove a constant line - it's affectively hard coding it.  so even when there isn't data the constant line isn't intelligent enough to not show as far as i can tell.