Forum Discussion

h11's avatar
h11
Icon for Helper III rankHelper III
2 years ago

Stack Column Chart to count the no of projects

Hi All,   I received an enhancement request for the solution (Solved: Re: Stacked Column Chart to show Count of Projects - Microsoft Fabric Community). Please assist me with the following:   We h...
Need Help
h11's avatar
h11
Icon for Helper III rankHelper III
2 years ago

Hi Sam,

 

Thank you for this solution. I really appreciate it.

 

The 3rd bar in the table should not be "Without" it should be a total of 1 and 2nd bar. 

 

For example - Solo Projects = 5

Projects with others = 7

3rd graph should show total of 1 and 2 i.e. 5+7 = 12

 

Thank you!

 

SamWiseOwl's avatar
SamWiseOwl
Icon for Super User rankSuper User
2 years ago

RETURN

SWITCH(

    selectedType

    ,"Solo Projects"

    ,COUNTROWS(FILTER(all('India vs Others'), 'India vs Others'[Vendor Site] = selectedVendor))

    ,"Projects with others"

    ,COUNTROWS(FILTER(all('India vs Others'),  'India vs Others'[Vendor Site] <> selectedVendor && CONTAINSSTRING('India vs Others'[Vendor Site],selectedVendor)))

    ,COUNTROWS(FILTER(All('India vs Others'), CONTAINSSTRING('India vs Others'[Vendor Site],selectedVendor)))

    )