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 that why my sales loss.

 

Regards,

Arvind

 

 

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”

5 Replies

  • 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,

       

      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.