What is the correct step to arrange month year source field ?

[Paulyeo11]

Hi All

I have create a template with year month source field , all can display nicely :-

when plaste to my transaction Tab , it also look very neat :-

when i return to home page , i click on the Transaction Button :-

Now the Transaction Tab month , year , source , Blank value label appear :-

May i know how to solve it ?

PAul

[tenfingers · Accepted solution]

The simplest solution would be to filter out the blank value from the column using a page or report level filter in the filter pane. 

[tenfingers]

An RI violation means that there is a value in your fact table that does not exist in your dimension table. So you can fix that by adding the missing value to your date dimension. Here is some info on RI violations:

https://www.google.com/amp/s/dax.tips/2019/11/28/clean-data-faster-reports/amp/ 

[amitchandak]

@Paulyeo11 , Seem like your company table is missing some company values, which are there in the fact/transaction table.

Please check that.

[tenfingers · Accepted solution]

The simplest solution would be to filter out the blank value from the column using a page or report level filter in the filter pane. 

[Paulyeo11]

Hi Tenfingers , 

Thank you for sharing.

so i need to setting every page. and save as bookmark.

Paul

[tenfingers · Accepted solution]

Hi Paul,

No you don't need bookmarks. you just need to open the filter pane and drag your Year Month column to the "Filters on all pages" area then unselect the blank value. This will remove it from the report. This is a solution but it doesn't fix the underlying issue that causes the blank which is a referential integrity violation.