Matrix - Breakup by FY Quarters

Power BI
1

Hello
I’m following through the module “Scenario Method Workshops” > “Financial Reporting in Power BI”.
I’m up to the point where I created the measure “FY Quarters” and tried adding it to the matrix “Column” field. Instead of my "Actuals (‘000’) being broken up by Quarters, I just have the “Actuals ('000)” column showing and the “Total” column. Did I miss something?

Please find attached my .pbix file

Thanks
Fiona

Financial Reporting_fone.zip (387.8 KB)

2

This is an easy one.

Your Months are text in the Financial Data table so your relationship in your model doesn’t know what to do.

image
image.png836×424 32 KB

Change this and it works as it should

image
image.png726×290 22.1 KB

image
image.png1030×312 25.6 KB

3

wow didn’t even notice that one, thanks heaps Sam.