Forum Discussion

saranyasaran's avatar
saranyasaran
Regular Visitor
9 years ago

line chart on filter selection

in line chart is it possible to get lines according to multiple country selection, for now its showing only average but I want to display for multiple country. Eg. Initially one line per chart will b...
Need Help
PowerDAX's avatar
PowerDAX
Resolver III
9 years ago

You should be able to simply add the country to the legend of the chart.

saranyasaran's avatar
saranyasaran
Regular Visitor
9 years ago

Hi,

Thanks for the reply. If i the country to the legend of the chart we get multiple lines, is there any option to get an average line initially and get multiple line based on filter selection.

  • PowerDAX's avatar
    PowerDAX
    Resolver III
    9 years ago

    you could do something clever with the DAX like checking if the country field is filtered (i.e. IF( NOT( ISFILTERED( 'Table'[Country])), xxxxx) and pass an ALL( 'Table'[Country]) filter if it was not filtered.