Dynamic Goal line in combo chart

[jasiekkal]

Hi,

I'm looking for a way to add a dynamic goal line to my combo chart that would change based on filtering context.

My visual is build bar charts showind total number of lines and line which shows one of 6 different measures that changes depending on selected measure name in one of the slicers. Additionaly there are other slicers like Region, Customer Name etc. 

The goal would not only be based on measure selection but also based on at least 2 additional slicers selected.

Let me know if it's possible or would you need additional details.

Best Regards,

Jan

[v-yuta-msft]

Hi jasiekkal,

You want to achieve some aggregation result based on selections in multiple slicers, right? You can use DAX formula like this pattern:

Result = Calculate(aggregation, allselected(table1), allselected(table2), ...)

Regards,

Jimmy Tao