cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MClipsham92 Frequent Visitor
Frequent Visitor

Measure displayed in Clustered Column chart not changing with slicer

Hello All,

 

I'm wirting a report on some student performance figures on various different programmes. I have written the report with the full data set selected and then have put in a slicer on the first page to filter the entire report by the programme number. This is working perfectly for the majority of my visuals, however I have two Column charts which display the percentage of students that improved in Confidence etc. To display this I have a conditional column which says improved if a students score is higher at assessment point 2 than at assessment point 1 and 'did not improve' if not. I then have this measure to work out the percentage;

 

Percentage of Students that improved in Confidence Link Teacher = DIVIDE(CALCULATE(COUNTROWS('Link Teacher'),'Link Teacher'[ Did student improve in Confidence]="Improved"),CALCULATE(COUNTROWS('Link Teacher'),'Link Teacher'[ Did student improve in Confidence]<> BLANK()))
 
The issue I am getting is when I select a singular programme the value doesn't change. I noticed this when I selected a programme which had entirely blank records in the 'Link Teacher' table. All the other visuals in the report that work off this table come up as blank when filtered to this programme.
 
Many thanks,
1 ACCEPTED SOLUTION

Accepted Solutions
MClipsham92 Frequent Visitor
Frequent Visitor

Re: Measure displayed in Clustered Column chart not changing with slicer

I have solved the issue I was having. What had happened was I'd introduced the slicer when I was half way through the report synced it up to page 6 which is where I was at with writing the report and then forgot to sync any pages after that.

2 REPLIES 2
MClipsham92 Frequent Visitor
Frequent Visitor

Re: Measure displayed in Clustered Column chart not changing with slicer

I have solved the issue I was having. What had happened was I'd introduced the slicer when I was half way through the report synced it up to page 6 which is where I was at with writing the report and then forgot to sync any pages after that.

Community Support Team
Community Support Team

Re: Measure displayed in Clustered Column chart not changing with slicer

That's great. 

 

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.