Forum Discussion
Don't see the "Analyze - Explain the decrease" option after September update
Hello,
Explain the increase / decrease has a few limitations with the first release, which is why it is still in preview.
You do not need to enable the preview switch as it is turned on for all. Here's a list of the type of queries it does not yet handle:
- TopN filters
- Include/exclude filters
- Measure filters
- Non-additive measures and aggregates
- Show value as
- Categorical columns on X-axis unless it defines a sort by column that is scalar. If using a hierarchy, then every column in the active hierarchy has to match this condition
- Non-numeric measures: model measure support is limited to sum and count only right now.
- Limitation in data conectivity
- Direct query
- Live connect
- On-prem RS
- Embedding
Keep an eye out for future releases with improvements.
So, if we want this feature work, we must have some conditions (in our tables, measures, columns). Can someone from Power Bi team tell us which are these conditions???
I concur that if someone from the team came back with what conditions this requires. After exploring further it is not alway clear what works and what doesn't and why.
One aspect that I have noticed that isn't the most useful is if I use a seperate 'Date' table to do the analysis then all the ML graphs come back using insights from what is happening on the 'Date' table, rather than the Fact table. If I use the date directly from the Fact table then I actually get useful insights. Normally I would prefer to hide all dates in my Fact tables and use Date Tables as a dimension.
A blog from the BI team about the nitty gritty of this feature would be excellent, especially if it explained in what conditions this feature will not work effectively.
This feature is not available if your data source is a SSAS I believe. Please confirm this to us PBI team.
Hooray, more features that look cool in demos but don't do anything for us! I was hoping this update would be full of those again.
