Forum Discussion
Values not affected by filter
Hi PaisleyMike,
The edit interaction is based on the full chart so the bar and lines will be or not affected by the slicers.
To have waht you want you need to place in the lines a calculated measure with a ALL sintax as filter.
As you can see below the red line is the measure i created in this case is:
Measure = CALCULATE(SUM(Table1[Budget]);ALL(Table1[Project]))
On the left you have a chart that don't have any interactions with the slicer in the right it as look at the red line and at the black line you will check that the red always stays the same:
Regards.
MFelix
Hi PaisleyMike
You have to got to Format > Edit interactions
And you have to click else on the filter icon or the other one
Quentin
Thanks
Also is there a way to do this withing a line and stacked Chart
e.g
Bar chart is able to change
Line chart remains unchanged
yes you can do that, there is the same option, you only have to click on the the slicer and then choose the filter on the line chart
Unfortunetly cant get it working
I can get it working with seperate chart but cannot get it working for this type of chart
which is a Line and clustered column chart
Hi PaisleyMike,
The edit interaction is based on the full chart so the bar and lines will be or not affected by the slicers.
To have waht you want you need to place in the lines a calculated measure with a ALL sintax as filter.
As you can see below the red line is the measure i created in this case is:
Measure = CALCULATE(SUM(Table1[Budget]);ALL(Table1[Project]))
On the left you have a chart that don't have any interactions with the slicer in the right it as look at the red line and at the black line you will check that the red always stays the same:
Regards.
MFelix