Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am having repeated line items in my pivot table below (see picture) .. the correct format should be Balance Sheet items appearing under the Balance Sheet section and likewise for Income Statement. I am guessing it might be something wrong with how the data model and/or Fact Tables being set up (see second picture for the data model). Can anyone kindly advise what are the changes required to achieve the desired format please?
ffwqfq
Hi @MZZH ,
The first thing I'd do is check that null values are null, rather than blank, in the source data.
If null values do not explicitly say 'null' in the value cell then you can either:
-1- Right-click on a blank value in your values column, select 'Replace value' and write 'null' in 'Replace With...'
-2- Filter out the rows which only have a blank value
The next thing would be to just filter the pivot table, where 'Value' <> BLANK() and <> null.
Pete
Proud to be a Datanaut!
Additonally, these are the simple dim tables: