Forum Discussion
Post Partisanrelationship - blank values on slicer
Community SupportHi cosminc
I try to create a pbix to reproduce your problem, but i can't get the right data model, could you have a look and point out what you have done and what you expect?
Best Regards
Maggie
Post Partisanhi
i attached an example on email
i established a relation one to many (both directions) between 2 data sets (i created an ID concatenation, the two sets have year, month and only the one has weeks columns); and i don't understand when i create a slicer with dimension months from first data set which has jan to jun data, a see as blank the months which aren't here but on the second data set (jul-dec)
scope: 2 visuals (one on monthly level from 1st data set and second on weekly level from 2nd data set, buttons on-off and slicers - but these slicers need to be an union items between the 2 basis, usable for both visual, that's why i create the relationship from data sets
Thanks
Cosmin