Forum Discussion
Helper IDInamic Line Chart of Sadness
Helper IHi v-yuta-msft , I did some research and found this. With the slicers you mean to change the entire X-axis right? Like one for Products and one for Categories?
That's not what I'm looking for... what I need to do is to create a table, based on the Start and End dates of each contract, here is a example:
Contract1 / Start= 01/01/2019 / End= 01/05/2019
Contract2 / Start=01/03/2019 / End=01/08/2019
The table should look like this:
Contract1 | January/19
Contract1 | February/19
Contract1 | March/19
Contract1 | April/19
Contract1 | May/19
Contract2 | March/19
Contract2 | April/19
Contract2 | May/19
Contract2 | June/19
Contract2 | July/19
Contract2 | August/19
Community Support
Where does the Contract1 / Start and Contract1 / End come from? Could you please clarify the logic?
Regards,
Jimmy Tao
- BlackBird
v-yuta-msft, sure.
These contracts, usually to provide services or rent equipment/machines, have all details like start and end dates, budget, scope, etc, defined on closure. But they can be altered while the contract is still active, like more budget or a longer/shorter end date.
I'm sorry if I'm not using the right terminology here, but I think you will understand. The dates/budget are defined acording to demand.
- v-yuta-msft
In the original table I haven't found any values which contains Contract1/Contract2. Please share the complete sample data so that I could do further analysis on it.
Regards,
Jimmy Tao
- BlackBird
https://drive.google.com/drive/folders/1JAQK1lUVxvIefVxlAYScfEtmlWGs8gTk
v-yuta-msftplease use the link above to download the file, it has the tables and the chart. Currently I'm using this excel file to arrange the data the way I need, and it's working fine.
By the way, parry2k thanks for sugesting making the excel file to explain things better, I'm actually using it now and the manager liked the result.
But still can't do it directly on pbi.