How to structure DataSource (Excel) vs PowerBI (Model)

Anonymous

Not applicable

4 years ago

Hi Vahid,

thank you!

I do not know how to best structure my model so that:

I get a fact-table containing info on the companies (Segment, SubSegment, Values per Segment/SubSegment, Name of company...)

I get my dim table to slice by different slicers:
- Toggle-slicers which only have TRUE or FALSE - F1 and F2 pictured below...
- Single-slicers which have ONE value - F3: either Glorb, Rok, Gnu or no Value. F4: either Gwerz, Glark or no value
- Multiple-options-slicers which can have several values - F5: is_regional AND sometimes is_listed AND sometimes is_bamo and F6: ...

I struggle with how-to-structure-my-filter-table (the picture is of the table after I pivoted several "multiple-slicer-options" columns).

At the moment this is my data model:

Because OrdnerTabelleFilters contains Filters as well as Filters' values for my companies I have to make the connection bi-directional.

My questions are:

Should I create one table containing values for ALL types of slicers (toggle, single, multi-option)?

Should I create a table containing values for EACH type of slicers?

If structured differently (separate Filters and Filter's values) - how do I connect the dim/fact tables?

Here`s my example-xlsx-source as well as the pbix:

Bye

Michael

Forum Discussion