Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have been trying to create column graphic includes Actual 22 and Budget 22 as values.
Budget values should be dashed line values like below picture and data label shows all values and Actual 22 values would be column. I could not do it. Do you know how I can do it the graphic like below. I could not find this format at google.
Solved! Go to Solution.
You can get very close with a Line and Stacked Column chart. Put the budget on the line and set the Stroke Width to 0 then turn on markers.
You can get very close with a Line and Stacked Column chart. Put the budget on the line and set the Stroke Width to 0 then turn on markers.
Thank you so much, I did it but I do not have line and stroke with part:( why? I just have following part.
Hi @Gamze ,
This can be done.
Assuming you have a transaction table containing your transactions or Actuals amount with their transaction date associated to the same.
Next you have a budget table containing your budget amounts with the date associated to the amount as well.
Next you have a date/calendar table that has relationships set up in the data model to your Transaction and Budget tables on their respective date columns.
Now, on to your chart visual:
Use the Date: Month from the Calendar Table on the x-axis. Use the Budget Amount from Budget table for the line axis, and Actuals Amount from the Transaction table on the column axis.
The aggregations for the Actuals and Budget amounts would be SUM (if itsn't already summing up by default).
You can set the nature of the Budget line to be dashed in the format pane of the visual.
You can also change the position of what totals and data labels are shown / visible from the format pane.
Hope this helps, tag me (@) if you need more help on it. Feel free to mark the answer as a solution if it helped you.
Thanks!
Unfortunately it does not work. I need the line as horizontal:(
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
84 | |
84 | |
67 | |
63 | |
62 |
User | Count |
---|---|
208 | |
121 | |
112 | |
79 | |
70 |