analyze - explain the increase/decrease

[gilr1975]

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 categories. I would like to see also Emp.Ids in this analysis option. Can I somehow define the categories I would like to see using analyze feature?

[gilr1975]

There is a feature https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-insights#:~:text=To%20use%20insight...

I try to use it in my charts:

It presents various useful information. It shows salary increase/decrease reasons in divisions and groups based on my data.

I would like analyze feature also show me more drill through analyzing and show also Emp.Id data. E.g. present Emp.Id for people that salary was increased, etc.

Can this feature be customized? I mean can I define which categories I would like to make an analysis based on? 

[v-yingjl · Accepted solution]

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.

[amitchandak]

@gilr1975 ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.