Stacked column chart in clustern column chart

Hi PhiBu ,

Looking at you data what I did was the following:

• Created a new table with the following values:

• Added the folowing 3 measures:

Estimated = IF(SELECTEDVALUE('Selection'[ID]) = 1 ; SUM('Jira-Issues'[Estimate Time  [h]]]); BLANK())

External = IF(SELECTEDVALUE('Selection'[id]) = 2 ; SUM('Jira-Worklogs'[External Time Spent [h]]]); BLANK())

Internal = IF(SELECTEDVALUE('Selection'[ID]) = 2 ; SUM('Jira-Worklogs'[Internal Time Spent [h]]]); BLANK())

Now create a Stacked Column chart with the following setup:

• Axis:
  • Month
  • Category
• Values
  • Internal
  • External
  • Estimated

Final result is in attach PBIX file (file in May version of PBI).

Be aware that the Hierarchy on the X-Axis need to be kept due to the setup what you can due is to concatenet the labels.