Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 😊
Solved! Go to 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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |