Forum Discussion

arvindyadav's avatar
arvindyadav
Post Partisan
8 years ago
Solved

Is Power BI Answer Why Questions?

Hi Team,   I need help regarding why questions in Power BI. Suppose I have data on sales and somehow I lose sales in this month So I want to know why I am getting the loss? So how can I predict t...
Need Help
  • MattAllington's avatar
    MattAllington
    8 years ago

    In Power bi desktop, create a line chart showing the trend with a date column as the x axis. 

     

    Right click on the point where sales declines

    select “explain the decrease”

MattAllington's avatar
MattAllington
Community Champion
8 years ago

In Power bi desktop, create a line chart showing the trend with a date column as the x axis. 

 

Right click on the point where sales declines

select “explain the decrease”

  • arvindyadav's avatar
    arvindyadav
    Post Partisan
    8 years ago

    Hi MattAllington,

     

    Thanks, It is very helpful.

     

    Regards,

    Arvind

  • arvindyadav's avatar
    arvindyadav
    Post Partisan
    8 years ago

    Hi MattAllington,

     

    It is explained nicely but I want why my sales were gone down. Which factors affect for this what I have to do.

     

    Regards,

    Arvind

  • caglaa's avatar
    caglaa
    Frequent Visitor
    8 years ago

    Hi MattAllington,

     

    I have just three options right click on the point those are "Show Data","Include" and "Exclude" in line chart. Why  “explain the decrease/increase” option may not appear?

     

    Thanks a lot.

  • caglaa's avatar
    caglaa
    Frequent Visitor
    8 years ago

    Hi MattAllington,

     

    I have three options right click on the point those are "Show Data","Include" and "Exclude". Why “explain the decrease/increase” option may not appear?

     

    Thanks a lot.