Forum Discussion

PhiBu's avatar
PhiBu
Icon for Helper I rankHelper I
6 years ago
Solved

Stacked column chart in clustern column chart

Hello everyone,    I would like to have a stacked column bar within my stacked column chart. Is this possible? My goal is to compare the estimated hours and working hours in our project in a stack...
Need Help
  • MFelix's avatar
    MFelix
    6 years ago

    Hi PhiBu ,

     

    Looking at you data what I did was the following:

     

    • Created a new table with the following values:
    Category ID
    Estimated 1
    Internal/External 2

     

    • 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.

     

MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 years ago

Hi  PhiBu ,

 

Not really sure if I understand from the image what are the values to sum but the option is to do the following:

  • Create a table with the two categories you want:

Type
Estimated
Actuals

 

Now create 2 measures:

Estimated = 
IF(SELECTEDVALUE(Table[Type]) = "Estimated"; SUM(Table[Estimated]); BLANNK() )

Internal = 
IF(SELECTEDVALUE(Table[Type]) = "Actuals"; SUM(Table[Internal]); BLANNK() )

External = 
IF(SELECTEDVALUE(Table[Type]) = "Actuals"; SUM(Table[External]); BLANNK() )

 

Now just add this 3 Measures on your stack chart and you should get internal on top of external and Estimated to the side.

 

Be aware that I'm assuming that you have a colum for estimated / interal / external but can be categories you just need to redo the measures accordingly.