Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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!
Solved! Go to Solution.
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
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
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
94 | |
90 | |
83 | |
75 | |
49 |
User | Count |
---|---|
145 | |
140 | |
109 | |
68 | |
55 |