I want to create a pareto diagram in Power BI. But every time i change the filters the diagram gets distorted. Let me explain – I have a column named indicator-where i have name of indicators which can repeat. In the second column i have the dates-which shows on what date corresponding indicator has been captured. I want to create a pareto which will which indicator is contributing most to the total. I tried the RANK function, but still after changing date filter in the slicer, everything goes disturbed. I used Pareto by Sio2graph (https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa200001423?tab=overview), and it worked for all my filters. But due to its limited customization, i can not use it. But yeah, if someone could help me write a general and robust dax for pareto just like by sio2graph. that will be helpful.