Power Pivot Dim table not reflecting the values of Fact table linked in data model

[StudentAlways]

Hi Experts,

I have for example, one fact table for the moment, I created unique elements in each separate tables and added to Data model.

Eg. Jira issue is linked to status etc so I created, Status as dimension table with unique values along with other columns I needed for filter.
When I created Pivot table and try to pull the Issue into rows and status dim, I was expecting Issue from fact table & Status from fact table should be same as Issue in the row column mapped to status from Status Dimension table. Attached is the sheet, i was working.
Here is the link  File Uploaded here 
Refer to the Sheet5 the first tab. I have one to many relationship from Dimension Status to Status in fact table. Please can you Kindly help me with details on what mistakes I am doing and why this issue is coming so I have 6 other dimension table that I need to use in the slicers.

Regards and Thanks

[dufoq3]

Hi @StudentAlways, you have 2 options:

1. use Status column from FactTab
   
   
   
2. Add some column to Values (because without this your pivot table is not filtered by dimension)

[StudentAlways]

Hi @dufoq3 Thank you but that is my question as I put it.

What is the point of making dimension table, if I cannot get the data needed and slicers I need.  From your response, you seem to suggest I must be using the values from the fact table. The advantage of dimension Table, I thought is if you have multiple fact tables, I thought the dimension tables are used for slicers and it would be easy. Please give me some examples on the data mapping, links and books I must use as this is bit confusing. Thanks a lot.

[dufoq3 · Accepted solution]

It is important to use STAR schema. Dimesion tables are important because you don't need to store repeteated rows. Check this and this article via sqlbi.

[StudentAlways]

Thank you @Payeras_BI  I am sorry, I have now updated with the right file for the consideration. In the power Pivot generated from Data model, I pulled Issue key and status from Dimension into rows, I was expecting the result is same as getting the information as I use fact table to get both issue key and status. But I think my understanding and logic is wrong. 

[Payeras_BI]

Hi @StudentAlways ,

please review the uploaded file as it appears to be incomplete based on the issue description.