Forum Discussion
decimals displaying incorrectly when applying RLS roles
- Anonymous9 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.
I don't know the issue, but instead of change the decimal format, you can perhaps use the round-function to get the useless decimalplaces killed? :)
- Anonymous9 years agoNot applicable
Thanks for that suggestion but if you can see my screenshots you'll see that this isn't a rounding issue. The numbers completely change.