Desktop

[NithinVK]

Hi,

I am creating a report and i wanted to make the Line graph to be constant. values should not change when i apply filter from Slicer. 

Regards,

Regards,

Nithin

[v-qiuyu-msft]

Hi @NithinVK,

You can create a measure with ALL() function to set line values not filtered by the slicer. For example, if the column you dragged to chart line values bucket is SUM aggregation, you can create a measure =CALCULATE(SUM(column),ALL(table)). 

If it doesn't meet your requirement, please share .pbix file with sample data for us. 

Best Regards,
Qiuyun Yu