Forum Discussion
shalini13
2 years agoRegular Visitor
Quarter data display in bar chart
hi , I want to display cumulative quarter wise data for the selected quarter in the slicer along with the previous quarter. for an instanace, if i select Q2, then the total sales value for the Q1...
Ahmedx
Super User
2 years agowith an active connection it will not work
shalini13
2 years agoRegular Visitor
Is there any other way to approach so that other charts in the page will not get affected. TIA
- Ahmedx2 years ago
Super User
you need to change the RELATION to inactive and change all the measures that are associated with them and activate them using USERELATIONSHIP
https://www.sqlbi.com/articles/show-previous-6-months-of-data-from-single-slicer-selection/