Forum Discussion

gilr1975's avatar
gilr1975
Icon for Helper I rankHelper I
6 years ago
Solved

analyze - explain the increase/decrease

Hello. I have charts that present salary data in different divisions, groups, teams, etc. When I use "analyze - explain the increase/decrease", it shows different explanations for a lot of categori...
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    Hi gilr1975 ,

    As the document mentioned, Power BI Desktop runs its machine learning algorithms over the data, and populates a window with a visual and a description that describes which categories most influenced the increase or decrease.  The algorithm can be thought of as taking all the other columns in the model, and calculating the breakdown by that column for the before and after time periods, determining how much change occurred in that breakdown, and then returning those columns with the biggest change. 

    In conclusion, the anynalze option calulated based on your whole report and gives us related result, we could not custom the feature currently. What we can change now is just change its visual types like the document mentioned.

     

    If you focus on this function, you can submit it to ideas to help us improve power bi and make this feature coming sooner: https://ideas.powerbi.com/forums/265200-power-bi-ideas

     

    Best Regards,
    Yingjie Li

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