Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
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
Solved! Go to Solution.
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”
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”
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.
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.
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
| User | Count |
|---|---|
| 23 | |
| 20 | |
| 19 | |
| 18 | |
| 10 |
| User | Count |
|---|---|
| 53 | |
| 53 | |
| 40 | |
| 37 | |
| 32 |