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.  

Anonymous's avatar
Anonymous
Not applicable
4 years ago

My preference would be for it to be blank as this is the behaviour when using small multiples.

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.