The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I wonder if possible to combine two tasks in one bar i.e., Period 1 & 2 adjacent to each other instead of beneath (show below).
I'm using Gantt Chart by MAQ.
Project Name | Type | Start Date | Period 1 | Period 2 |
Project A | Simple | 01/02/2022 | 01/02/2022 - 01/03/2022 | 02/03/2022 - 31/03/2022 |
Project B | Medium | 02/03/2022 | 02/03/2022 - 31/03/2022 | 01/04/2022 - 30/04/2022 |
Solved! Go to Solution.
Hi @AnnaTokyo ,
Please try:
Start_Date = CALCULATE(MIN('Test'[Start Date]),REMOVEFILTERS(Test[Period]))
End_Date = CALCULATE(MAX('Test'[End Date]),REMOVEFILTERS(Test[Period]))
Output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @AnnaTokyo ,
Please try:
Start_Date = CALCULATE(MIN('Test'[Start Date]),REMOVEFILTERS(Test[Period]))
End_Date = CALCULATE(MAX('Test'[End Date]),REMOVEFILTERS(Test[Period]))
Output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @AnnaTokyo
Would it be possible for you to attached your PBIX file removing any sensitive data?
Hi @Seanan
Thank you for your reply. Here is the link to the sample data set and Power BI file. Thank you for your time in advance.
https://drive.google.com/drive/folders/1BE39-2zSwy2cpUeKP9tKFMpLRdqc4b5v?usp=sharing
Hi @AnnaTokyo
Apolgies for the delay in getting back to you.
Unfortunately, I wasn't able to find a way to combine your periods to make them adjacent to each other. Sorry I couldn't be of more help.
User | Count |
---|---|
16 | |
8 | |
7 | |
6 | |
5 |
User | Count |
---|---|
25 | |
13 | |
12 | |
8 | |
8 |