We have line chart. When we right click on the line chart, we have “Analyze which leads us --> Explain the increase or Explain the decrease”. It didn’t work at Sumx measure. My measure is
Total Sales = Sumx(‘Detail Sales Order Lines’,’
Detail Sales Order Lines’[Quantity]*‘Detail Sales Order Lines’[UnitPrice])
So, I just created new calculated column and put in the line chart. It worked.
Therefore, I found out the Sumx didn’t work for analyze measure at line chart.
Well this option is still activated under SUMX also. The thing is you might have just clicked on the chart whereas to analyze through that option we need to click on that particular “Line”. Below are the screenshot provided for the reference where I’ve created charts via measure based on SUMX and the other chart contains the figures based on calculated column.
By clicking on that chart the “Analyze” option will not get activated we’ll be required to click on a “Line”
Hello @Harsh Thank you for the file. Yes, we still have analyze. But it didn’t work. In other words, it can’t produce any insight as per attached photo. I tested it at the file you kindly sent me.
So this is something I also actually didn’t knew until you figured it. So basically there are several limitations for quick insights.
I found out when I read this documentation from the Microsoft. I’m providing links below where this same type of query was also asked onto the Power BI Community.
Hi @KhinKyeSin, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Also, we’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!
