mrchonginhk
Well-known Member
- Joined
- Dec 3, 2004
- Messages
- 679
In my data, 2018 includes items A,B,C only (eg values 10, 20, 30)
2017 contains data for item A, B, C, D (eg values 15,25,35,45)
In my Matrix report in PowerBI, I am showing 3 columns:-
Item, 2018Values, 2017Values
2017Values is a DAX measure created using SAMEPeriodLastYear.
Then I have a filter selecting Year.
When I select year 2018 in slicer,
2017Value (ie lastyear) column is showing correctly.
However, what is missing is item D is not in my report. Now it is shown as
Item , 2018 , 2017
===============
A , 10 , 15
B, 20, 25
C, 30, 35
The problem I have now is D actually is a 2017 item but it is not showing in the above Visual. What I need is:-
Item , 2018 , 2017
===============
A , 10 , 15
B, 20, 25
C, 30, 35
D, 0, 45
What can I do to ensure D is also shown while year 2018 is selected ?
Thanks
2017 contains data for item A, B, C, D (eg values 15,25,35,45)
In my Matrix report in PowerBI, I am showing 3 columns:-
Item, 2018Values, 2017Values
2017Values is a DAX measure created using SAMEPeriodLastYear.
Then I have a filter selecting Year.
When I select year 2018 in slicer,
2017Value (ie lastyear) column is showing correctly.
However, what is missing is item D is not in my report. Now it is shown as
Item , 2018 , 2017
===============
A , 10 , 15
B, 20, 25
C, 30, 35
The problem I have now is D actually is a 2017 item but it is not showing in the above Visual. What I need is:-
Item , 2018 , 2017
===============
A , 10 , 15
B, 20, 25
C, 30, 35
D, 0, 45
What can I do to ensure D is also shown while year 2018 is selected ?
Thanks