Graphing measures of different tables on the same axis

[Symphony88]

Hello, I have 10 measures from 5 different tables which I would like to graph on the same axis. I created a table with the distinct years (FY) to create a relationship. Based on what I can see with a table. The bar chart is displaying the empty values of other years and as a result each FY is aligning as it should but I really would like to supress the blank values so the graph only displays the two measures per FY. How can i achieve this?

[amitchandak]

@Symphony88 , for that you have to create a calculation group and use that on the axis with Year, -> Expand-> Sort on axis -> Concatenate label off

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

Concatenate Label off : https://youtu.be/QgI0vIGIOOk

[Symphony88]

@amitchandak Thank you much for your reply, however I do not have access to tabular editor and I do not have permission to download it. Is there any other way I can create calculation grouping without using the tabular editor?