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.
I have been experimenting a touch with trying to get this to work, and have finally managed to find the feature and understand under what circumstances it appears to work.
It appears that it doesn't work on some types of measures.
I had a measure that was
CALCULATE(COUNTROWS('Table'), 'Table'[BooleanColumn]))
My Boolean column was used to identify if a particular outcome had occurred.
In this style, the Analyze feature did not appear.
However if I change the boolean column to a 'Whole Number' type, so all replaced with 1s and 0s and changed my measure to
SUM('Table'[NumberVersionOfBooleanColumn])
In this method the Analyze feature DOES appear.
In my case I don't even have a calculated measure. I have displayed normal table data values in a bar chart. Nevertheless I cannot see the new functionality. Does anyone have a clue?
thanks and br