Clustered bar chart with generic Y-axis

[Anonymous]

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

[V-lianl-msft]

Hi @Anonymous ,

I think you need to create another Calculated columns or measure by using allexcept as the filter condition.

Could you please share sample data sample pbix?(Please mask any sensitive data before uploading)

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vanessafvg]

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.

[Anonymous]

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?