Database structure - create relationships

[Strider_Elessar]

Dear all, I'm quite new in the Power BI. We use a sort of ERP and power BI is linked to it. I can see the databases and it seems that in order to create proper relationships I might have to change a bit the structure.

Indeed it looks like this:

This table is then linked to another one through the FirmenID that returns the names, etc.

The column "PHKeys" refers to attributes in the ERP and it's quite difficule to then create relationships between them.

I tried to duplicate the table into small ones, but then the relationship doesn't seems to work between the duplicates.

And I'm not even mentionning the dates!

Any idea?

[Eric_Zhang]

@Strider_Elessar

According to your description, it seems not too duplicated. A relationship based on my understanding would be like

[Strider_Elessar]

Hi,

Thanks for your feedback, then how can I search and get info from the DB with more than 1 criteria ?

Indeed I would need the date > than a date to be selected in a slicer + a certain value from the PHKey to return a value from the Content column?

[Eric_Zhang]

@Strider_Elessar

As long as the relationship is set up properly, you can use 2 slicers, one for Dim_Date[date] and another for Attributes[PHKEY]. They two cooperate to fliter the data. There exists interactions amont visuals.

[Strider_Elessar]

Hi,

is it also possible to have 3 slicers :

-two on the attributes PHKEY first would be about the department and second one about the category

-on for the date?

If so, how?

Thanks!

[Eric_Zhang]

---

@Strider_Elessar wrote:

Hi,

is it also possible to have 3 slicers :

-two on the attributes PHKEY first would be about the department and second one about the category

-on for the date?

If so, how?

Thanks!

---

@Strider_Elessar

Using what in the slicers is all depending on your data model and requirement. By the way, I don't quite get category in your post.