Forum Discussion

Invisibleman's avatar
Invisibleman
Helper II
3 years ago

Problem with mapping and the schema in Power BI

Dear all,   I have an inventory file, where there are 4 columns. Those columns I want to set in 1 selection (1 slicer). For this, I created for each column a mapping and then 1 mapping (I called it...
Need Help
lbendlin's avatar
lbendlin
Super User
3 years ago

A lot of these tables can bew collapsed/combined  but here's how I would envision the data model.

 

Invisibleman's avatar
Invisibleman
Helper II
3 years ago

Hello Ibendlin,

 

Thanks for the reply. But if I do like so, then I will need to create the slicers for the "Is Cost WH", "Inv WH", "Is HK WH" and the "Is NIAC WH". And I want to get those in 1 slicer and from there select or de-select to get the combination you need. Or am I mistaken and missing something?

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    You should not attempt that since the values come from different columns. Use separate slicers or - better - filter pane filters.

    • Invisibleman's avatar
      Invisibleman
      Helper II
      3 years ago

      Hello Ibendlin,

       

      Thanks for the information.

       

      However, is it for the people, that need to work with the final report, it will be easier to have this in the slicer. However, as I may read from your remark, that is not possible the way I think could be. At least that is then what I think, you mean.

       

      Then I will need to think for the way, to get all the columns data in 1 field (that it will be like "YYNYNYNN" and then to see to have the information for the actual selected of the slicer to get the same kind of string. And then from there make the filtering.

       

      So we have something to think about and to figur out.

       

      Anyway, thanks for your fast replies and the support.

       

      Regards,

      Hans