Grouping by different conditions

[AAPBI]

Hi,

I'm rather new to using power bi, and this might be answered multiple times by now, but I couldn't get it to work for me.

I have a table that contains different account numbers and types from different channels, and I'd like to count the number of accounts opened based on the account types and channel.

my data looks something like this

acct no	acct type	channel
321	SAV	2
21231	CUR	2
231654	NTD	1
23132	VEV	3
231	VEV	1
51	STD	3
21	SAV	2
314	SAV	1

I need to create the below graph

in sybase, I would do something like this

select acct_type, channel, count(acct_no)

from my table

group by acct_type, channel

how can that be done in power bi

thank you 😊

[amitchandak · Accepted solution]

@AAPBI , Take acct_type, channel on Axis, and legend to Clustered column visual or vice versa .

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart