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 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

1 Reply

  • 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