Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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,
Solved! Go to Solution.
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
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
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?
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
@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
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
@aj1973 thanks for replying. What I expect is: when 2021 & all the months are selected, then data for only 2021 Jan,feb & march should be displayed in the matrix The issue is that its displaying 2020 data as well. It was displaying data beyond March 2021, that I handled by including the following 'If' condition in the measure:
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
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
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 |
---|---|
109 | |
102 | |
84 | |
79 | |
70 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |