Need to use measure on both axis of bar chart

[mayankhginfra]

Hello,

I am building a report for one of my client where I need to show the count of equipments for first 10 days of month, classified into two categories (<3, >3).
1: Data record on everyday basis.

2: We need to take average of Total_WH (working hours)

3 Sample data as below:

Plant	Plant_Name	Equipment_No	Date	Objecct_Description	Total_WH
1134	UER-PKG-I	HEOT101329	07-08-2023	HYDRA CRANE	10.7
1134	UER-PKG-I	HEOT101329	01-08-2023	HYDRA CRANE	10.5
1134	UER-PKG-I	HEOT101329	02-08-2023	HYDRA CRANE	10.6
1134	UER-PKG-I	HEOT102345	01-08-2023	HYDRA CRANE	13
1134	UER-PKG-I	HEOT102345	10-08-2023	HYDRA CRANE	11.5
1134	UER-PKG-I	HEOT102345	02-08-2023	HYDRA CRANE	11
1134	UER-PKG-I	HEOT102345	06-08-2023	HYDRA CRANE	15
1134	UER-PKG-I	HEOT102345	04-08-2023	HYDRA CRANE	14.2
1134	UER-PKG-I	HEOT102345	07-08-2023	HYDRA CRANE	11.6
1134	UER-PKG-I	HEOT102345	03-08-2023	HYDRA CRANE	12
1134	UER-PKG-I	HEOT102345	08-08-2023	HYDRA CRANE	10.4
1134	UER-PKG-I	HEOT105375	07-08-2023	HYDRA CRANE	12.5
1134	UER-PKG-I	HEOT105375	01-08-2023	HYDRA CRANE	11
1134	UER-PKG-I	HEOT105375	06-08-2023	HYDRA CRANE	8.2
1134	UER-PKG-I	HEOT105375	03-08-2023	HYDRA CRANE	11.9
1134	UER-PKG-I	HEOT105375	04-08-2023	HYDRA CRANE	13.5
1134	UER-PKG-I	HEOT105375	08-08-2023	HYDRA CRANE	11.3
1134	UER-PKG-I	HEOT105802	04-08-2023	HYDRA CRANE	19.3
1134	UER-PKG-I	HEOT105802	06-08-2023	HYDRA CRANE	13.6
1134	UER-PKG-I	HEOT105802	09-08-2023	HYDRA CRANE	12.8
1134	UER-PKG-I	HEOT105802	01-08-2023	HYDRA CRANE	11.1
1134	UER-PKG-I	HEOT105802	10-08-2023	HYDRA CRANE	15.4
1134	UER-PKG-I	HEOT105802	08-08-2023	HYDRA CRANE	11.4
1134	UER-PKG-I	HEOT105802	05-08-2023	HYDRA CRANE	10.5

I need to build a visual similar as below:

[mayankhginfra · Accepted solution]

For any one who facing similar kind of issue.

I did solved it with the help of goupping in a disconnected table. You have to try different aggregations and BOOM its done.

[mayankhginfra]

FYI: I have created a measure to count distinct equipment where date range is between 1-10 and have also taken the average of Total_WH.

DistinctCount_Equipment =

COUNTROWS(

            SUMMARIZE(

                FILTER(

                    ZC_PM_EPR,

                    DAY(ZC_PM_EPR[Date]) >= 1 && DAY(ZC_PM_EPR[Date]) <= 10

                ),

                ZC_PM_EPR[Equipment_no],

                "Total_WH", DIVIDE(SUM(ZC_PM_EPR[Total_WH]), 10)

            )

)

major issue i am facing is to get X-axis as shown in visual above. Since we do not have any such column in table and also the table is based on per day data and I need to classify it on first 10 days of the month basis.

[v-zhangti]

Hi, @mayankhginfra 

You can't put a measure on an X axis. Calculated columns can be added and used as X-axis.

Best Regards,

Community Support Team _Charlotte

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