Forum Discussion
Don't see the "Analyze - Explain the decrease" option after September update
Hello friends,
In September's update there supposed to be a nice feature of explaining decrease/increase.
It is described here:
https://www.youtube.com/watch?time_continue=817&v=moTQJlnClJw
The problem is that I don't see this option when right clicking a chart column.
I did use a date column from a time dimension and a stacked column chart as described.
But no "Analyze" option....
Please help.
Thank you
Michael
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.
21 Replies
Hello to all,
Same problem here.
Because it is a preview feature I thought to look at options but nothing there too.
ver2.50.4859.502 64-bit
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.
Good morning,
I have exactly the same issue. I've downloaded and installed Power BI Dekstop x64 Version: 2.50.4859.502 64-bit (September 2017)
I can't wait trying this feature.
Thanks in advance.
Kind regards,
Lohic Beneyzet
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.
Hi Anonymous,
The "Analyze - Explain the decrease" option is available in my test.
But, if there is only one column bar in chart, this option will disappear.
Could you share your sample data or pbix file so that I can test in my environment?
Regards,
Yuliana GuI 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.
Hi Yuliana,
It seems to work only with simple measures such as SUM(Column).
If I try the simple Average() or some other calculated measure - there is no option to Analyze.
Also if I connect to SSAS - it doesn't appear even for simple Sum() measures.
Please specify for all of us - when this usefull feature is usable.
Thank you!
Michael
