Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
HI.. I have calculated measure which I am trying to display on a trend line graph. There are two graphs that display 8 weeks historical attrition and 8 week pipline attrition respectively. For simplicity lets say the fomula is sum(week exits)/sum (week head count).
Now..for the pipeline graph, I need to use the the (static) head count value of the 8th week (from historical attr) as denominator, meaning sum(future exits)/sum ( week head count (latest week)). The issue here is when I do so..the result is correct when i use a card visual ..however when I use the graph the same further filters/splits the denominator in context of the future weeks, thus generating an incorrect denominator..
The ask here is can how can I keep the denominator in the measure static (like freezing value in excel) while still allowing the numerator to fitler itself basis the X axis of the graph...at the same time the denominator should respond to the slicers and other filters on the page.
Illustration below:
ask: the pipeline attrition measure should use 170 as denomiator (this is been achieved) however it is splitting 170 in context on week 9 and later thus ruining the denominator.
Historical | |||
AC | HC | Measure (AC/HC) | |
week 1 | 10 | 100 | 10% |
week 2 | 20 | 110 | 18% |
week 3 | 30 | 120 | 25% |
week 4 | 40 | 130 | 31% |
week 5 | 50 | 140 | 36% |
week 6 | 60 | 150 | 40% |
week 7 | 70 | 160 | 44% |
week 8 | 80 | 170 | 47% |
Pipeline | |||
week 9 | 10 | 170 | 6% |
week 10 | 20 | 170 | 12% |
week 11 | 30 | 170 | 18% |
week 12 | 40 | 170 | 24% |
week 13 | 50 | 170 | 29% |
week 14 | 60 | 170 | 35% |
week 15 | 70 | 170 | 41% |
week 16 | 80 | 170 | 47% |
thanks in advance
Hi @shaashn
Has your problem been solved ? If it has been solved, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regard
Community Support Team _ Ailsa Tao
Hi @shaashn
Is the value of column [HC] a regular value or a calculated column ? When the week is 9 , what is the value for [HC] ?
If so, can you provide the pbix file and the result you think is correct ? This will help us better deal with the problem.
Best Regards
Community Support Team _ Ailsa Tao
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
71 | |
56 | |
39 | |
35 |
User | Count |
---|---|
66 | |
66 | |
59 | |
53 | |
45 |