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.

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

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 Gu

sokg's avatar
sokg
Solution Supplier
8 years ago

v-yulgu-msft

 

Please tell me , in your test, "Sales" is a measure or just a column in a table????

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    It is a column in my data with values that PBI sumed.

    However, when tested using a measure using Sum it also works.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      What helped me is stripping back my data model to just a few tables to see how this feature works before moving back to my full model (and realising that I need to change a lot of my existing models if I wish to use this feature)