Needing help Create custom parallel interactive bar chart
I need help with creating the middle chart The dashboard looks like butterfly chart for hires and exits, with a parallel bar chart in the middle showing headcount and promotions for each headcount grade level -as Power BI lacks this visual I am trying to do it with python but I am unable to find the right code to generate the middle graph and make it interactive with the bar charts on the left and right. ** so the requirement is creating three subplots: left for hires for each career level, middle for headcount/promotions for each career level *up of each other* in parallel and showing the (number, percentage ), and right for exits, all sharing the same y-axis (career levels).Break a Line Graph when no data
Hi, Is there anyway to break a line graph when no data is present on a combo bar/line graph? No data was collected from 2019-2022 and the bars reflect this, however the lines look like there is data: I have tried to change to type to 'Categorical' however this then doesn't show it in date order, which it needs to be as it needs to show yearly changes in numbers. I could set to 0 but that would then look like there was sharp increase from 2022 to 2023 so ideally looking for a full break if possible. Is there a solution to this? Thank you
Cumulative Cost Measure - Line Graph Stop Flat Lining Out
Hi there! I have created a cumulative cost measure within one of my reports which is cumulating cost values over a 15 year period however I am not so happy with the visual which I will explain. My data is split into 3 Cost Types (Legend) - Earned, Planned, To Go. All three are showing fine on the line graph & 'Planned' will remain the same and show the trajectory over the 15 year span, however my value for 'Earned' is projecting until the current reporting month and then it is just flatlining as the cumulative value is remaining the same. I want this line to stop on the reporting month and when nothing further is cumulating to the 'Earned Value'. Also on the 'To Go' Value this works in the opposite and is only starting to project from the reporting month, and flatlining at 0 up until then so I would really want this line to not show until the reporting month and start projecting from there onwards. Any tips and suggestions would be greatly appreciated, below is the current DAX I am using to cumulate my values. Cumulative Cost = CALCULATE( SUM('EV Data Pivot'[Month Value]), FILTER( ALLSELECTED('EV Data Pivot'), 'EV Data Pivot'[Month] <= MAX('EV Data Pivot'[Month]) ), VALUES('EV Data Pivot'[Control Account]), VALUES('EV Data Pivot'[Cost Type]) ) ----- (Also may be worth noting I have replaced my date hierarchy on X Axis with a custom dateTable relationship for text values for FY, Quarter, Month to align with financial year reporting.)
