Pareto chart with live connection

Hi Migscruz ,

As you said, you can't create calculated columns and tables in live connection mode, but you can create Pareto visual with measure.

Here is a sample:

https://www.mssqltips.com/sqlservertip/6152/how-to-create-a-pareto-chart-in-power-bi-desktop/ 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.