topic Visualize bins with unique measure values in DAX Commands and Tips

Visualize bins with unique measure values

sivaadityat — Mon, 16 Oct 2023 17:00:40 GMT

Hello All,

I got a requirement in Headcount utilization with below scenario. I am looking a help to visualize bar chart with both measures in X and Y axis.

Scenario: I have calculated headcount and utilization percentage based on hours spent by each employee and converted utilization into bins. Now, I would like calculate headcount(unique emp ID's) based on bins calculated in measures(Bins - Utilization%).

As measures are not supported in Bar graph X axis, I am facing issue. Please find the example excel sheet below for reference.

EMP ID	Client Facing Headcount	Client Facing Hours	Utilization %	Bins - Utilization%
A100	1	40	100%	100 - 200%
A101	1	50	125%	100 - 200%
A102	1	60	150%	100 - 200%
A103	1	70	175%	100 - 200%
A104	1	80	200%	100 - 200%
A105	1	90	225%	200 - 250%
A106	1	100	250%	200 - 250%
A107	1	110	275%	250 - 300%
A108	1	120	300%	250 - 300%
A109	1	130	325%	> 300%
A110	1	140	350%	> 300%

Note: please note that headers mentioned in red color above are Measures.

Any inpus / help is highly appriciated.

Thanks,Siva

Re: Visualize bins with unique measure values

Anonymous — Wed, 18 Oct 2023 01:47:47 GMT

Hi sivaadityat ,

Please try to create a calculate column for bins, then add it to the X axis.

In Power BI, X axis do not support measure.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Visualize bins with unique measure values

sivaadityat — Wed, 18 Oct 2023 09:33:59 GMT

Hi Anonymous

Thanks for the reply. I tried calculating calculated column for binning for this issue. But, as I am calculating this bins based on a measure value, it is giving a aggrigated value for all rows.

Re: Visualize bins with unique measure values

Anonymous — Wed, 18 Oct 2023 10:21:52 GMT

Hi sivaadityat ,

Please try to create a calculate column with VAR keyword, use the VAR keyword to define the based calculate logic.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.