Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

decimals displaying incorrectly when applying RLS roles

A previously existing report that has worked properly for months is no longer displaying decimal data correctly when viewing as role for 5 of the 7 roles that are defined in the report. The other two...
  • Anonymous's avatar
    Anonymous
    9 years ago

    The problem is a bug that seems to have a relationship to DirectQuery, row level security, page filters, and data volume. There is a page level filter being applied that constrains the results to records from the current month when the following logic returns "TRUE"

     

    My Filter = MONTH('Date[Transaction Date]) = MONTH(TODAY()) && YEAR('Date[Transaction Date]) = YEAR(TODAY())

     

    The above was created as a field that was added to the Page Filters and constrained the results to records returning "True". When this filter was removed the problem went away but there was no other way to achieve the required data set without this filter. Through trial error I eventually discovered that also adding the filter field to the table itself fixed the problem. I was then able to squeeze the width of the column to be so narrow that it was not noticable when placed at the far right of the table.

     

    I hope this fix to this obscure problem benefits someone some day. I expended a great deal of time figuring this out. Let me know if you have encountered this too.