Reply
Visitor
Posts: 1
Registered: ‎09-14-2018

Need Help. Line graph to be constant

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,

Capture.PNG

Regards,

Nithin

Highlighted
Moderator
Posts: 9,419
Registered: ‎03-06-2016

Re: Need Help. Line graph to be constant

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 

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