Forum Discussion

thehowlerr's avatar
thehowlerr
New Member
9 years ago
Solved

clustered bar chart - multiple columns from two sources

I have a bar chart that shows the number of items of a particular status by Design team (see chart below).   I would like to had columns by Design team that counts items by of a particular type as we...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    Hi thehowlerr,

     

    You could create a new table, which will summarize the table by "type" and "status". Then you can create visuals with the new table. Any new data added into the old table will be updated in the new table automatically. Please have a try.

     

    ResultTable =
UNION (
    SUMMARIZE (
        'DataTable',
        'DataTable'[Status],
        'DataTable'[Design Team Report],
        "value", COUNT ( 'DataTable'[Status] )
    ),
    SUMMARIZE (
        'DataTable',
        'DataTable'[Type],
        'DataTable'[Design Team Report],
        "value", COUNT ( 'DataTable'[Type] )
    )
)

     

     

     

     

     

     

     

     

     

     

     

     

    I paste your data in text mode in case somebody wants to have a try.

    Type	Status	Design Team Report
NC	Open	C7A
NC	Closed	N/A
NC	Closed	PP
RFI	Closed	WS
NC	Ready to Inspect	PP
NC	Open	PP
NC	Ready to Inspect	PP
NC	Open	PP
NC	Closed	PP
RFI	Closed	SGH
NC	Ready to Inspect	PP
NC	Ready to Inspect	SGH
NC	Closed	SGH
NC	Closed	SGH
NC	Closed	SGH
NC	Closed	SGH
NC	Closed	SGH
NC	Closed	WS
NC	Closed	WS
NC	Closed	WS

    Best Regards!

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
9 years ago

Hi thehowlerr,

 

You could create a new table, which will summarize the table by "type" and "status". Then you can create visuals with the new table. Any new data added into the old table will be updated in the new table automatically. Please have a try.

 

ResultTable =
UNION (
    SUMMARIZE (
        'DataTable',
        'DataTable'[Status],
        'DataTable'[Design Team Report],
        "value", COUNT ( 'DataTable'[Status] )
    ),
    SUMMARIZE (
        'DataTable',
        'DataTable'[Type],
        'DataTable'[Design Team Report],
        "value", COUNT ( 'DataTable'[Type] )
    )
)

 

 

 

 

 

 

 

 

 

 

 

 

I paste your data in text mode in case somebody wants to have a try.

Type	Status	Design Team Report
NC	Open	C7A
NC	Closed	N/A
NC	Closed	PP
RFI	Closed	WS
NC	Ready to Inspect	PP
NC	Open	PP
NC	Ready to Inspect	PP
NC	Open	PP
NC	Closed	PP
RFI	Closed	SGH
NC	Ready to Inspect	PP
NC	Ready to Inspect	SGH
NC	Closed	SGH
NC	Closed	SGH
NC	Closed	SGH
NC	Closed	SGH
NC	Closed	SGH
NC	Closed	WS
NC	Closed	WS
NC	Closed	WS

Best Regards!

Dale