Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
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/
@Paulyeo11 , Seem like your company table is missing some company values, which are there in the fact/transaction table.
Please check that.
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.
Hi Tenfingers ,
Thank you for sharing.
so i need to setting every page. and save as bookmark.
Paul
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |