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 I ask what it is you are expecting it to do when there is no data?  to be blank?  A little unsure of what you are asking can you explain what you expect to happen in the problematic quadrant.

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