Skip to main content
cancel
Showing results for 
Search instead 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

Reply
shaashn
Frequent Visitor

Freezing filter context while visualizing using a graphs

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   
 ACHCMeasure
(AC/HC)
week 11010010%
week 22011018%
week 33012025%
week 44013031%
week 55014036%
week 66015040%
week 77016044%
week 88017047%
    
Pipeline   
week 9101706%
week 102017012%
week 113017018%
week 124017024%
week 135017029%
week 146017035%
week 157017041%
week 168017047%

 

 

thanks in advance

2 REPLIES 2
v-yetao1-msft
Community Support
Community Support

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

v-yetao1-msft
Community Support
Community Support

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

Helpful resources

Announcements
Europe Fabric Conference

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.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors