Search code examples
chartspowerbivisualizationdata-analysispowerbi-desktop

Have removed summarisation but still adding count when brought into graph - Power BI

I'm trying to just show a flat line of 20 across a graph. I've added a column in my Shift Activity table that's just 20 for every value.

enter image description here

I've set it to a whole number data type and I've selected "Don't Summarize"

enter image description here

However when I bring this field into the yaxis of my graph I it consistently summarises it as "Count of Target"

enter image description here

And the graph shows the count, not a horizontal line of the value.

enter image description here

Thoughts appreciated.

Solution

  • To add a constant line, don't add any data but add a reference line instead.

    enter image description here