Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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 p...
Need Help
  • kimani's avatar
    kimani
    8 years ago

    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.

lbeneyze's avatar
lbeneyze
Advocate II
8 years ago

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

  • lbeneyze's avatar
    lbeneyze
    Advocate II
    8 years ago

    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

    • kimani's avatar
      kimani
      Power BI Team
      8 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        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.