Dynamic Line values

[Anonymous]

Hey,

I Have 3 different tables that contain 3 different products sold. At all the 3 tables, the column that contain the sales values called "Gross Sales".

Now I'm trying to create one stacked column chart that will show me the execution for each month and a line that will show the daily average sales for the month. The shared axis is Month, which taken from date table i've created.

1. I tried to create an appended table but every row contain the type of the sale, so the dates at the appended table multiplie.

2. I want to make the line dynamic, so every type of sale i choose at the slicer, it will automatically calculate the daily average. I loaded a table that contains for every month of the year how many working days there are (we calculate working days differently than usual in the industry)

Thanks!

[Greg_Deckler]

@Anonymous - Difficult to say exactly given the information provided. Please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

All of that being said, this might help? https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-EVERYTHING-measures-axis-legend-titles-chart-types/m-p/1027881#M444