topic Re: Relationships in Custom Visuals Development Discussion

Relationships

LCarenzo — Tue, 25 Jun 2019 19:52:21 GMT

Hi - I am having some trouble. I want to create a dashboard view with multiple tabs of data. I have a source file for each month (12). I need to build multiple relationships, but Power BI will not allow me to do it. For example I want to see Issues, then Issue Count by Month. Next I want to see Client, then Issue Count by Month.

Not working.....

Re: Relationships

v-evelk — Thu, 27 Jun 2019 15:50:51 GMT

Hi,

I am not sure that I understood the point.

Power BI can relates data among tables .

Could you please make some pictures to demonstrate what exactly you want to achieve?

Kind Regards,

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

Re: Relationships

LCarenzo — Thu, 27 Jun 2019 16:01:07 GMT

Happy to however I cannot seem to attached an image.

Let me help to explain further.

I have one visual that show the Count of an Issue by month. Jan-May and my relationship is build based on the issue. Issue to Issue. My second visual is Client - count of Issue by month. The relationship of Issue to Issue no longer works.

Re: Relationships

v-evelk — Fri, 28 Jun 2019 13:49:58 GMT

Still cannot figure out what data model you want to build, sorry.

Could you please describe tables and their relationships in details, may be with some fake data if your data is confidential?

Also, you could ask in the following threads because experts there have more strong expertise regarding building of data models:

https://community.powerbi.com/t5/Desktop/bd-p/power-bi-designer

https://community.powerbi.com/t5/Service/bd-p/power-bi-web-app

Kind Regards,

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com