Forum Discussion
Variance bar chart
I currently have two visuals as shown below. What I would like is for the right visuals figures to match the lefts but as a summary. there is a lot going on in the background data wise but currently ...
You could create a measure and add it as a tooltip
Total Actual Cost per Sub Assembly = CALCULATE( SUM(SubAssemblies[Actual Cost (£)]), ALLEXCEPT(SubAssemblies, SubAssemblies[Sub Assembly]) )
Hi Anonymous
You'll need to write a DAX measure that uses the correct relationship to get the right visual working.
Please provide sample data so that I can replicate the issue to provide a detailed fix.
This is the standard sheet
This is the sheet containing the serial number and engine type
Thanks, no measure needed actually.
I used dummy data as images aren't usable here.
Add the serial number to the y-axis on the bar chart visual
Click the expand hierarchy button on the visual
It will display sub assembly and serial number concatenated.
I hope this helps, please give a thumbs up and mark as solved if it does, thanks!
Hi, thank you but mine doesn't seem to do this