Pareto chart with dynamic time slicer

[Anonymous]

Hi everyone,

I am trying to create a pareto chart of different failures from different processes inside a company. I managed to make everything as it should be, but one thing I would like to implement is time slicer. Meaning, that one can use this slicer to check the situation from Jan - December 2018, or June 2018 - June 2019.

https://powerbi.tips/2016/10/pareto-charting/

I guess that in that case the complete calculation should be done differently, or am I wrong?

Help greatly appreciated.

[v-chuncz-msft]

@Anonymous ,

Keep in mind that values in a calculated column and calculated table are fixed, while the calculated results of measures are always changing in response to your interaction with your reports.

[Anonymous · Accepted solution]

Thanks for the tip, it actually did help me although I managed to create it by following this example.

https://xcelanz.com/dynamic-pareto-chart-in-power-bi/