Constant Line loses its format

[Anonymous]

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 duration in Days/Hours format and all works well until one of the quadrants doesn't have an entity to display in it and then the constant line displays but without its custom format.

Any ideas on why it loses its format? Also, given there's no entity to report on based upon the selection why is the constant line displaying? If I convert the 4 visuals to a single visual with the region as a small multiple, the constant line behaves that way.

[vanessafvg]

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]

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

[vanessafvg]

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]

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

[v-easonf-msft]

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 · Accepted solution]

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

[vanessafvg]

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.