Forum Discussion

nh27's avatar
nh27
Helper III
1 year ago
Solved

Help creating a stacked chart by multiple columns

Hi, I am trying to create a stacked bar chart which shows 4 products currently split by column and there are different phases of the product. I have attached sample data and expected output. Is th...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi nh27 ,

     

    I made a sample for you with dax.

     

     

    Measure = SWITCH(SELECTEDVALUE('Table'[Value]),
"Product A",COUNTROWS(FILTER('Table1',NOT(ISBLANK([Product A])))),
"Product B",CALCULATE( COUNTROWS(FILTER('Table1',NOT(ISBLANK([Product B])))),USERELATIONSHIP(Table1[Product B],'Table 2'[Value])),
"Product C",CALCULATE( COUNTROWS(FILTER('Table1',NOT(ISBLANK([Product C])))),USERELATIONSHIP(Table1[Product C],'Table 2'[Value])),
"Product D",CALCULATE( COUNTROWS(FILTER('Table1',NOT(ISBLANK([Product D])))),USERELATIONSHIP(Table1[Product D],'Table 2'[Value]))
)

     

     

    Best Regards,

    Wearsky

nh27's avatar
nh27
Helper III
1 year ago

Hi, thanks for this. I have already test this method and it worked, just wasn't sure if there was another way to do this via DAX Measures and whatnot.

rajendraongole1's avatar
rajendraongole1
Super User
1 year ago

create separate measure for each phase in Power BI as like below:

Phase1_Measure = SUM(Products[Phase1])
Phase2_Measure = SUM(Products[Phase2])
Phase3_Measure = SUM(Products[Phase3])