Forum Discussion
Measure doesn't allow right report slicing
Hi Community,
I have two dim tables- Datedim & Empdim. Empdim is related to two other tables. There is a measure 'Hrs Productivity' in empdim that I have on a matrix layout. This measure is not slicing the year/months properly: for example if 2021 is selected, the measure makes the data to be displayed for prior months/year.
Here is my Pbi file: https://1drv.ms/u/s!Ag919_pO_UKrgReCwuTjqZXdT9fW?e=HGZjvg
Many thanks in advance,
Ok 2 things to change
Use Date hierarchie in your Matrix and Also date hierachie in your Slicer Year(don't Use column Year
Voila
5 Replies
Hi Anonymous
Trying to understand your issue, is it why the cells are empty when you select 2021? if so what are you expecting to see?
aj1973 No this is not the case. The issue happens when I bring in the measure 'Hrs Productivity' from Empdim table on to the matrix. Please check my PBI file in the post.
If I create 'Hrs Productivity' in any of the other 2 tables (Query1 & Hrs_worked, relating to Empdim) then it resolves the issue of incorrect slicing but I get incomplete data.
I did, that's why I am asking and you are not telling what you want to see!!
Ok Play with your 'a' variable maybe I am close to understand what you are looking for