Should we create a measure to use in the chart or should we use the filter pane instead?

[hongthuong_hvtc]

Should we create a measure to use in the chart or should we use the filter pane instead? Which one is good for the Power BI performance?

I want to visualize the amount for expense type by date. I have many expense type (cost of good sold, adminitrative expense, labour expense, selling expense,.....) but I just want to visualize some of these expense type in the chart. So should I use filter pane to filter the expense type or should I write the measures to caculate the amount for each expense type?

[pratyashasamal · Accepted solution]

Hi @hongthuong_hvtc ,
It is better to filter on page level .On performance, it is always tricky thing, I wouldn't expect it will be much of a different and you can always check with performance analyzer to see how long it take using two approaches. 

Don't create measures if allowed. Some DAX functions will take up more CPU and RAM resources.

A comprehensive guide to Power BI performance tuning 

Improve Power BI Performance by Optimizing DAX 

Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C