The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a data set with 4 columns. Column A = Company Name, Column B = Financial Year, Column C = Days of Working Capital and Column D = Industry Name.
I am trying to create a custom bar chart that shows the median days working capital for each industry for the financial year 2018. Can someone please help with a formula?
Company Name | Financial Year | Days Working Capital | Industry |
A | 2018 | 2 | Retail |
A | 2017 | 5 | Retail |
B | 2018 | 3 | Retail |
B | 2017 | 6 | Retail |
C | 2018 | 4 | Retail |
C | 2017 | 7 | Retail |
D | 2018 | 5 | Pharma |
D | 2017 | 8 | Pharma |
E | 2018 | 6 | Pharma |
E | 2017 | 9 | Pharma |
F | 2018 | 7 | Pharma |
F | 2017 | 10 | Pharma |
Solved! Go to Solution.
Hi,
You can create the median with the function in Power BI.
Hi @HellRaizer2310 ,
Let me know if you'd like to get the result like this :
Median = CALCULATE(MEDIAN('Table'[Days Working Capital]),ALL('Table'),VALUES('Table'[Financial Year]),VALUES('Table'[Industry]))
Pbix attached here: https://wicren-my.sharepoint.com/:u:/g/personal/dinaye_wicren_onmicrosoft_com/EX0PmQRDUGdHq14Wlvq6gC...
Hi @HellRaizer2310 ,
Let me know if you'd like to get the result like this :
Median = CALCULATE(MEDIAN('Table'[Days Working Capital]),ALL('Table'),VALUES('Table'[Financial Year]),VALUES('Table'[Industry]))
Pbix attached here: https://wicren-my.sharepoint.com/:u:/g/personal/dinaye_wicren_onmicrosoft_com/EX0PmQRDUGdHq14Wlvq6gC...
Hi,
You can create the median with the function in Power BI.