line month to month in a stacked column chart that contains 2 sources of data Options

[Anonymous]

Hi

I'm new in Power BI and need some help! literally driving me crazy because in excel it's easy to do. 

In excel, the chart with line and stacked column chart is made with 2 sources of data (see screenshot below). If I select a project on the slicer that contains the data for the other source will show the line with the proper data by month. In the case of Power BI, there is that option but don't know how to combine it. If I select on the slicer the Project that I want to review, only show the total of both years, not the total month to month. (see screenshot below)

The matrix table on the top right corner it's showing the data month to month (Source "S4A DATA"), that's the line that want to add on the "line and stacked chart" on the low right corner (Source "Claims 2018..."). I add it but only show the total amount (as a steady line), not month to month. Please can you show me how can I do that?

Thank you.

[v-jiascu-msft]

Hi @Anonymous,

There could be a missing relationship in Power BI. Different data sources are combined with the relationship in Power BI.

I would suggest you create a date table if you don't have one. Then establish proper relationships. 

If the suggestion doesn't help, please provide a dummy sample? Please don't share anything confidential. 

Best Regards,

[Anonymous]

The table that need to create I made it directly as a matrix table in power BI (see screenshot below)

This matrix table is pulling the info from"S4A DATA" source, "Project" as the rows and "Crash date" as the columns. Need to create this "matrix table" as a new source table, don't know exactly how.

[v-jiascu-msft · Accepted solution]

Hi @Anonymous ,

Usually, we can use such a middle table in a measure. I don't know what you are going to do. I only can suggest a formula like below, which creates a calculated table.

Table =
SUMMARIZE (
    'S4A DATA',
    'S4A DATA'[Crash_Date].[Year],
    'S4A DATA'[Crash_Date].[Month],
    'S4A DATA'[Project],
    "Count of Crash_Date", COUNT ( 'S4A DATA'[Crash_Date] )
)

Best Regards,

[Anonymous]

Why post the exact same response twice in a thread? Obviously, if he didn't use your solution the first time, he chose not to use it (likely because it wasn't clear). Posting the same thing ad nausea is nothing but wasted bandwidth and a frustration to users. Yes, you may know the solution but do you know how to accurately convey it?