Forum Discussion
Visualization in Power BI
Hi luqmaanr,
Can you share the expected result, please?
1. Which value will be on the Column, which value will be on the line?
2. Which value will be cumulated?
3. Please download the demo in the attachment. Is it the one?
Best Regards,
Dale
Hi Dale
Thanks for responding, much appreciated.
1) Planned, Forecast and Actual will be the column data, cumulative planned, cumulative forecast and cumulative actual will be line as secondary axis
2) Planned, forecast and actual will be cumulated
See attached photo as an example from the below table.
| Bidders List Approved - PLAN | Bidders List Approved - FORECAST | Bidders List Approved - ACTUAL | Bidders List Approved **bleep** Planned | Bidders List Approved **bleep** Forecast | Bidders List Approved - **bleep** Actual | ||
| Jan-18 | 1 | 1 | 1 | 0 | 0 | 0 | |
| Feb-18 | 2 | 3 | 4 | 2 | 3 | 4 | |
| Mar-18 | 11 | 6 | 6 | 13 | 9 | 10 | |
| Apr-18 | 15 | 12 | 10 | 28 | 21 | 20 | |
| May-18 | 5 | 5 | 5 | 33 | 26 | 25 | |
| Jun-18 | 5 | 8 | 9 | 38 | 34 | 34 | |
| Jul-18 | 5 | 4 | 5 | 43 | 38 | 39 | |
| Aug-18 | 9 | 8 | 7 | 52 | 46 | 46 | |
| Sep-18 | 11 | 13 | 14 | 63 | 59 | 60 | |
| Oct-18 | 3 | 7 | 4 | 66 | 66 | ||
| Nov-18 | 3 | 6 | 0 | 69 | 72 | ||
| Dec-18 | 0 | 0 | 0 | 69 | 72 | ||
| Jan-19 | 1 | 1 | 0 | 70 | 73 | ||
| Feb-19 | 0 | 0 | 0 | 70 | 73 | ||
| Mar-19 | 5 | 1 | 0 | 75 | 74 | ||
| Apr-19 | 0 | 1 | 0 | 75 | 75 | ||
| May-19 | 0 | 0 | 0 | 75 | 75 | ||
| Jun-19 | 0 | 0 | 0 | ||||
| Jul-19 | 0 | 0 | 0 | ||||
| Aug-19 | 0 | 0 | 0 | ||||
| Sep-19 | 0 | 0 | 0 | ||||
| Oct-19 | 0 | 0 | 0 | ||||
| Nov-19 | 0 | 0 | 0 | ||||
| Dec-19 | 0 | 0 | 0 | ||||
| Jan-20 | 0 | 0 | 0 | ||||
| Feb-20 | 0 | 0 | 0 | ||||
| Mar-20 | 0 | 0 | 0 |
Hi luqmaanr,
The problem here is how we can get the data in your second post from the data in your first post. I can't find any connection.
Can you modify the demo I attached before?
Best Regards,
DaleHi Dale,
The data in my second post is from Excel, using the same format of the data from my first post. I was able to do it in Excel, but found Power BI can easily connect to application and we want to utilitze it.
In excel, I can write my formula to count (COUNTA) the Planned date <= today() for each month and same for forecast. But for actual no need, you can just COUNTA.
I want to achieve the following.
1) Planned, Forecast and Actual will be the column data, cumulative planned, cumulative forecast and cumulative actual will be line as secondary axis
2) Planned, forecast and actual will be cumulated
3) % ontime = Planned vs Actual - Planned is to count all the planned date <=today ().
I cannot attach excel file in this forum, please let me know if you need additional info.
Thanks Again.
Hi luqmaanr,
I don't know which parts you already have and which parts you expect. Please download the demo in the attachment. Is it the solution?
Why does the **bleep** column start from 0?
Best Regards,
Dale