Creating a matrix in Power BI with measures and excel data

[Anonymous]

Hello Power BI Community,

i'm new to the forum and overall new to Power BI Desktop.
I didnt find the right post to my issue so i hope you can help me. If there is already a post with a solution to this, i apologize and would be glad if you can link it.

I have multiple measures created in Power BI using DAX and a standard calendar.

I placed the measures and years like this: 

and set the value setting to: 

that i receive that type of matrix: 

Now my question: Can i integrate a column with data out of excel and place it that i receive something like this? 

Thanks!

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

According to your description, here's my solution.

1.Add a row in the original column or create a new table like this:

Table 2 = UNION(VALUES('Table'[Year]),ROW("Year","Column"))

Get this column.

2.Modify the measures like this:

Measure1 = IF(MAX('Table 2'[Year])="Column",111,123)

In your sample, you should change the 123  to the your original Measure1 formula.

In this way, modify other measures, get the expected result.

I attach the sample below for reference.

Best Regards,
Community Support Team _ kalyj

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

[Greg_Deckler]

@Anonymous I think that would require a custom matrix hierarchy: (3) The New Hotness (Custom Matrix Hierarchy) - Microsoft Power BI Community

[Anonymous]

Thanks @Greg_Deckler for your answer! 

I'm not quite sure, but i think i mean something different. 

Like the data out of the Excel column is related to each measure (DAX) of my matrix. 
For example: Measure1 equals 123 in each years. The new column from Excel should show the target value like 110. 

Each Measure has maybe different target values and i want them next to each measure as shown above. The main issue i have is that i can't get the excel file connected with the DAX measures right.
I dont even know if this is possible or not 😐