Forum Discussion

jasiekkal's avatar
jasiekkal
Icon for Advocate I rankAdvocate I
8 years ago

Dynamic Goal line in combo chart

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...
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
8 years ago

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