Forum Discussion
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 ...
According to your description, it seems not too duplicated. A relationship based on my understanding would be like
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?
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.
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!