Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello all, this is my 3rd post in a row for this year and I thank the community for supporting and helping me actually learn alot through these solutions which the experts suggest.
Here I have another table as below :
Month | Cumulative | Target | Actual |
2022 | 0.23 | ||
2023 | 0.35 | ||
2024 Target | 0.25 | ||
2024 Actual | 0.34 | ||
Jan-24 | 0.25 | 0.44 | |
Feb-24 | 0.25 | 0.23 | |
Mar-24 | 0.25 | 0.36 | |
Apr-24 | 0.25 | ||
May-24 | 0.25 | ||
Jun-24 | 0.25 | ||
Jul-24 | 0.25 | ||
Aug-24 | 0.25 | ||
Sep-24 | 0.25 | ||
Oct-24 | 0.25 | ||
Nov-24 | 0.25 | ||
Dec-24 | 0.25 |
Further I need a combine graph where-in, I have my Yearly cumulative on bar graph and on the same visual I need to also showcase Line graph showing the 2024 monthly actual vs target:
Requesting for support, I have tried many times but I am not exactly able to get what I need.
Thank you
Solved! Go to Solution.
Hi @TejasShah ,
Thank you for @lbendlin 's quick reply. Based on the information you have provided, you may consider dividing the table into two parts to put in a bar chart and a line chart respectively, and then combine the two charts to achieve the result you want. You can follow the steps below:
1.Copy a new table in Power Query. Keep the first four rows for the first table and delete the first four rows for the second table. Add an index column to both tables.
2. Put the data into the visuals respectively, put the index column into tooltips and sort them in ascending order according to the index column.
3. Adjust the range of y-axis between 0-0.5, open Data labels, close the Title of Y-axis and X-axis.
4. Select two visuals at the same time, use Ctrl+G to combine the two visual objects.
Final output:
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired out put and pbix file without privacy information.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @TejasShah ,
Thank you for @lbendlin 's quick reply. Based on the information you have provided, you may consider dividing the table into two parts to put in a bar chart and a line chart respectively, and then combine the two charts to achieve the result you want. You can follow the steps below:
1.Copy a new table in Power Query. Keep the first four rows for the first table and delete the first four rows for the second table. Add an index column to both tables.
2. Put the data into the visuals respectively, put the index column into tooltips and sort them in ascending order according to the index column.
3. Adjust the range of y-axis between 0-0.5, open Data labels, close the Title of Y-axis and X-axis.
4. Select two visuals at the same time, use Ctrl+G to combine the two visual objects.
Final output:
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired out put and pbix file without privacy information.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You seem to already have the solution. Not sure what you need assistance with?
Hello @lbendlin ,
This graph is on a excel sheet, I need the similar one in PowerBI which I am not able to get it. Requesting for support/help. Thanks