cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Strider_Elessar Frequent Visitor
Frequent Visitor

Database structure - create relationships

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:

2017_03_09_12_00_45_Guest_presence_test_Power_BI_Desktop.jpg

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?

5 REPLIES 5
Moderator Eric_Zhang
Moderator

Re: Database structure - create relationships

@Strider_Elessar

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

 

Capture.PNG

Strider_Elessar Frequent Visitor
Frequent Visitor

Re: Database structure - create relationships

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?

Moderator Eric_Zhang
Moderator

Re: Database structure - create relationships

@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 Frequent Visitor
Frequent Visitor

Re: Database structure - create relationships

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!

Moderator Eric_Zhang
Moderator

Re: Database structure - create relationships


@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.