Forum Discussion

cosminc's avatar
cosminc
Post Partisan
8 years ago

relationship - blank values on slicer

Hi, I created an ID (a concatenation from couple of columns) and a relation between 2 data basis. many to one with both cross filter direction And i don't understand something: a column slicer fro...
Need Help
ricardocamargos's avatar
ricardocamargos
Continued Contributor
8 years ago

Hi cosminc,

 

Are you sure that the one side contains all ID's from many side ?

  • cosminc's avatar
    cosminc
    Post Partisan
    8 years ago

    No 1 base 2018 jan-jun and 2nd 2016-2018 jan-may The idea is when i made a relationship, the slicer has to have all options as an union, no matter if i use slicer with months dimension from 1 base or from second. Now i see items from 1st base and also as blanks the non common items which are in the other base but not on the first one.

    1st data base is also split on weeks so i have many id month-year and 2nd data base is not on weeks..so one id for the concatenation month-year

    Many to one relations
    how would you manage this?

    Thanks!

    Cosmin

    • v-juanli-msft's avatar
      v-juanli-msft
      Community Support
      8 years ago

      Hi 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

      • cosminc's avatar
        cosminc
        Post Partisan
        8 years ago

        hi

        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