The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi all,
I hope one of you can help me with the following question:
I want to put the following 4 graphs in 1 clustered bar chart:
When I try to do this, however, I end up having a clustered bar chart that shows me the same numbers 4 times:
The problem might be in my x-axis definition, since I only put in 'inactive calls' there, but I don't know how to fix it and show me different numbers.
Can anyone help?
Cheers,
Sander
hi @Anonymous
Is it possible to demonstrate what you are expecting, essentially you are counting the rows, what are you wanting to measure?
do you want all active to be clustered on top of each other rather than side by side?
You will probably have to create a field that you can place on the legend with an IF statement. If you can provide a little bit of dummy date and give a clear idea of what you are expecting i can put it togther for you.
Proud to be a Super User!
Hi both,
Thanks for the replies. You can see some dummy data here:
I will simplify my problem with two categories, calls and data. I want to know, how many users (out of 1412) have not used their calls or data bundles (e.g. user 101 in the dataset above). So I defined two extra columns, "Call user types" and "Data user types", stating if a customer is 'active' or 'inactive' for respectively the call and data bundles. In this example, the customer would be marked as 'inactive' caller if the sum of columns B, C, D, E and F is "0". Otherwise, he would be "active".
I want to show the total active vs total inactive users over the two categories in one clustered bar chart. So for this, I think I need to set up a generic y-axis, stating 'Active' and 'Inactive'. And then I want to show the total active call users and total active data users in the 'active' part of the Y-axis. Analogue to the inactive customers.
Is this possible?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
92 | |
90 | |
72 | |
69 |
User | Count |
---|---|
232 | |
128 | |
117 | |
82 | |
82 |