How to fix SELECTED YEAR ACTUALS values to showing in matrix by year

DAX DAX Calculations
1

Help, please :slight_smile:

I cannot figure out why the SELECTED YEAR ACTUALS value are not showing in the breakdown by year in matrix visuals.

Thank you.

Financial Reporting In Power BI - Practice.pbix (625.1 KB)

2

Hi,

Your date table relation is not right may be becuse the data type of both is not same as you can see in the below screen shot :
image
When i put your month and date side by side only balnk come from date table

The reason is month is text format and date is date type which is not correct .
You need to change the text to date and that you can do it on M side or in Table view choice is your and report will start giving you the desired result as shown in the below screen shot:

image
image718×424 48.4 KB

Let me know if i need to share the PBIX then i will .

Thanks,
Anurag

2 Likes
4

Hi Anurag

Thank you for your feedback.
I see your point on text vs date data types.

Many thanks. SOLVED! :slight_smile:

5

nice solution @Anurag to bad you didn’t get the solved pointed to your message

6

I thought I did point the SOLVED in the thread.
Did I miss it?