Forum Discussion
Measure filtering within Graphs not functioning as expected
Hi JamesLindsay101 ,
//From how it's interacting, it looks like the filtering occurring to split up the measure into the bars looks like it's filtering the measure [Past 12 Month Sick Days] but not the [Active Employees] and [Headcount (12 Months Prior)] measures. However, when I use a filter on the page for those departments, it does in fact filter the whole measure, and not produce the issue described above.
Do you use the same column for the axis and filter in your scenario?
In addition, try to put "Annualised Sickness Ratio" measure into the bar chart and check if there are any difference compared with the result in the card.
Best Regards,
Icey
Hi JamesLindsay101 ,
//From how it's interacting, it looks like the filtering occurring to split up the measure into the bars looks like it's filtering the measure [Past 12 Month Sick Days] but not the [Active Employees] and [Headcount (12 Months Prior)] measures. However, when I use a filter on the page for those departments, it does in fact filter the whole measure, and not produce the issue described above.
Do you use the same column for the axis and filter in your scenario?
In addition, try to put "Annualised Sickness Ratio" measure into the bar chart and check if there are any difference compared with the result in the card.
Best Regards,
Icey