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.
Based on the reactions, I've tried several things.
I discover that:
1. my calculated measure wasn't working. I've stripped it down to a simple "SUM"
2. I was using a custom date hierarchy using "addcolumns": i've replaced it with a simple date columns.
Then I could use the Analyse button! Yeah!!!
Thanks a lot fellows for the comments
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.
Thanks for clarifying this - that's really helpful! It would have been helpful of the Power BI team to make this explicit in the release notes, rather than forcing many of us to take ot the forums to find out why the new feature isn't working.
That list is fairly comprehensive. Personally I would have preferred that they wait a couple of months and release something properly, than ship something that doesn't work in 80% of use cases.
Hi,
Thanks indeed for the clarification. This is a huge help in order to "test" this feature. Like Anonymous is writing, it would be have been more friendly if the conditions to have it work have been explained instead of discovering on our own.
Unlike Anonymous, I'm very very happy you have released this feature. It gives us the possiblity to test it and to influence the course of your development. Based on the past 2 years, Power BI dev team has shown to be truely "agile" and will improve this feature the coming months. I'm sure of that. Keep up the good job!Kind regards,
Lohic Beneyzet
"Ever tried. Ever failed. No matter. Try Again. Fail again. Fail better.d go on failing fast!" (Samuel Beckett)
- I also appreciate the clarity on this feature and agree with ibeneyze entirely.
This will also help you I bet in managing the questions from users who are excited but frustrated with your about what a feature currently can and cannot use. I am sure if users were more aware of the limitations then they would be able to more easily feedback what is most important for them for future releases of a feature.
All and all, your product is amazing and keeps me on my toes to incorporate these regular significant features throughout my organisation.
Hello,
I was looking for the answer, why Analyze button doesn't work, when you 're embedding the chart on links.
Have you fixed it?
