Creating Clusters
Syed Ahmed Ali ???? ????
Data Analyst @ Majid Al Futtaim | Data Analyst, BI Developer | Power BI, SQL, Python
Its about the clusters.
I have created a scatter chart with the measure of Profit Margin and Revenue of y and x axis respectively. Then the chart is dispersed by the Products showing PM and Revenue for each product.
To create those dynamic clusters, first have to create a measure which will give us the average of Revenue and Profit Margin.
After that we can write a measure for color which will work on the colors by comparing the each value to the average. We can define different values to be compared with, depending on our requirements.
Place it in the color conditional formating like the following and its done. You can maually create legends as well to show the meaning of your cluster.
To check the report, go to the link below :
Senior Business Intelligence Developer | MBA
2 年This is great, thank you for posting.
Top Linkedin Voice in Data Analysis| Data Analyst & ML Expert | Skilled in Machine Learning with Python & R, BI Developer using Power BI & SQL | Driving Business Growth through Data Insights
2 年Awesome
Environmental Solutions Advisor/AMSS MidCon Manager @ Cimarron | BI Expert, Power BI
2 年This is great!!
LinkedIn Top Voice | Product Manager | Data Visualization & Power BI Speaker | #TheWeeklyChart Author | #DataDNA Ambassador | Researcher
2 年It so great.