cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper III

## Creating a line chart with limit (drawings included***)

Hello,

I have two datasets in this example. Example = Tracks daily employee hours by store to avoid overtime exceedances.

Table1 = a basic template that has the daily hourly limits for a store

Table 2 = contains records for daily hours logged at a store

What I want is for my chart to have a "limit" line. So for store A, the line should be at 521 always. And then the daily records of 216 and 321 (in this example) should be shown.

My Issue is that whenever I use the area chart is Power BI, it sums my columns. So instead of it being 521 for store a (I have a filter going), its around 2000. There is no "Do Not Summarize" option for this chart. When I do a table, I can get exactly what I want, so why can't I do this for the chart??????

Thanks!

1 ACCEPTED SOLUTION
Memorable Member

Hi @water-guy-5,

You can use:

``Limit A = CALCULATE(SUM('Table1'[Employee Hours]), FILTER('Table1', 'Table1'[Store] = "A"))``

Then show this value by using a constant line.

Works for you? Mark this post as a solution if it does!
Consider taking a look at my blog: Forecast Period - Previous Forecasts

Memorable Member

Hi @water-guy-5,

You can use:

``Limit A = CALCULATE(SUM('Table1'[Employee Hours]), FILTER('Table1', 'Table1'[Store] = "A"))``

Then show this value by using a constant line.

Works for you? Mark this post as a solution if it does!
Consider taking a look at my blog: Forecast Period - Previous Forecasts

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.