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

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.